How to Use ISNA Function

The ISNA Function is to check whether a value is #N/A error.




Value is required, the result returns TRUE when the value is #N/A error, and returns False when it is not.



Cell A2 is Text, not #N/A error, so ISNA(A2) returns False.


Cell A3 is #N/A error, so ISNA(A3) returns True.

Download ISNA Function

Leave a Reply