1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Re: Removing #N/A from formula results

    From Jake Johnson@21:1/5 to roger...@gmail.com on Sat Jan 22 17:57:18 2022
    On Saturday, March 4, 2017 at 8:28:59 AM UTC-5, roger...@gmail.com wrote:
    If you have XL2007 or later, you could just wrap your formula in IFERROR()

    =IFERROR(your formula,0)
    Just use the =IFNA(your formula))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)