ISNA
Description
If the specified value or expression results in an #N/A error, returns TRUE; otherwise, returns FALSE.
Syntax
ISNA(
value
)
- value: The value or expression to evaluate.
Example
Formula | Result |
|---|---|
=ISNA(123) | FALSE |
=ISNA("phrase") | FALSE |
=ISNA(12/0) | FALSE |
=ISNA(A1) where A1 contains #N/A | TRUE |