OR and ISNA not giving expected result.

[Snypa]

I have the following formula:

=OR(isna(C8), C8="None")

• When C8 matches neither condition it returns False
• When C8 = None, it returns True
• However, when C8 is #NA it returns #NA - and not True

=OR(isna(C8))

returns True when C8 is #NA

Can anyone offer any insight, am I doing something wrong or how else might I achieve what I want?


Thanks in advance,

 

[Joe4]

I believe the issue is that it tries evaluating both expressions, and if C8 is #N/A, then C8="None" will also return #N/A.
Try using an IF, in which you can prevent the evaluation of C8 if it is #N/A, i.e.

=IF(ISNA(C8),TRUE,IF(C8="None",TRUE,FALSE))

 

[Snypa]

I believe the issue is that it tries evaluating both expressions, and if C8 is #N/A, then C8="None" will also return #N/A.
Try using an IF, in which you can prevent the evaluation of C8 if it is #N/A, i.e.

=IF(ISNA(C8),TRUE,IF(C8="None",TRUE,FALSE))

Okay, that works.

 

[Scott Huish]

Perhaps:
=IFERROR(C8="None",TRUE)

 

[sandy666]

little shorter: =IFNA(C8="None",TRUE)

 

[Snypa]

IFERROR works but, alas, IFNA is not on my version of Excel; I don't even have IFS!

 

[sandy666]

you didn't show your excel version
but ok if IFERROR works for you
have a good day