Testing for #N/A results in #N/A instead of TRUE

[DashboardNovice]

I expected the two yellow cells to evaluate to TRUE because I am testing K10:K16 for #N/A and the last two values are #N/A.

Why are the last two cells resulting in #N/A instead of TRUE?

 

[AliGW]

Because you are testing for text, not an error. Try this:

=ISNA($K$10:$K$16)

The hashtag followed by N/A will be seen by Excel as an error message, not regular text. Same with #VALUE!, for which you could use =ISERROR($K$10:$K$16)

 

[DashboardNovice]

The hashtag followed by N/A will be seen by Excel as an error message, not regular text.

That explains it. I always had trouble with #N/A errors when I would check for them. I don't know why I didn't think about using ISNA( ).

This is very helpful. Thank you.

 

[AliGW]

You also have IFNA, so you an provide a fallback:

=IFNA($K$10:$K$16,"")

 

[DashboardNovice]

You also have IFNA, so you an provide a fallback:

=IFNA($K$10:$K$16,"")

Thank you for reminding me about that one. Sometimes it's easy to forget obvious things.