Description
Determines if the specified expression returns the value not available error.
Syntax
ISNA ( expression )
| Parameter | Description |
|---|---|
| expression | Any expression. |
Remarks
If the expression returns the #N/A! error, ISNA returns True. Otherwise, returns False.
Examples
This function returns True if cell S1 contains the NA ( ) function or returns the error value #N/A!:
ISNA(S1)
See also