ISNA(value)

Returns the value True or False depending if the value is #N/A.

valueThe value you want to test.

Remarks

* The "value" can refer to a value, cell reference, formula or a named range.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISREF function to return True or False depending if the value is a cell reference.
* For the Microsoft documentation refer to support.office.com

 A
1=ISNA(#N/A) = True
2=ISNA(C-13) = False
3=ISNA(INT("")) = False
4=ISNA(100) = False
5=ISNA("some text") = False
6=ISNA(named_range) = True


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top