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...