Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
May 04, 2021
Solved

#NA - ISERROR

Experts,   How can I display a 0 on #NA?  I thought the last 0 would do so but it still says #NA.  I also tried to wrap with ISERROR but maybe I did it wrong.     thank you.    =IF([@[Issued Or...
excel
  • mathetes's avatar
    mathetes
    May 04, 2021

    Tony2021 

     

    I can't take the time to decipher your formula. Let me just offer this: when I'm writing a conditional formula, I first work to get it to work correctly--which includes giving me an #NA or other error when such errors are "the right answer"...once it's working correctly and I now want to wrap with IFERROR it's easy,

    =IFERROR(working formula,"")

    or

    =IFERROR(working formula,0)

     

    The potentially counter-intuitive thing about IFERROR is that you put the working (non-error) formula first, and your replacement if there IS an error comes last. It's backward compared to the standard IF function.

mathetes's avatar
mathetes
Gold Contributor
May 04, 2021

Tony2021 

 

I can't take the time to decipher your formula. Let me just offer this: when I'm writing a conditional formula, I first work to get it to work correctly--which includes giving me an #NA or other error when such errors are "the right answer"...once it's working correctly and I now want to wrap with IFERROR it's easy,

=IFERROR(working formula,"")

or

=IFERROR(working formula,0)

 

The potentially counter-intuitive thing about IFERROR is that you put the working (non-error) formula first, and your replacement if there IS an error comes last. It's backward compared to the standard IF function.

Resources