Checks whether the specified value is the #N/A error value.
Syntax
 Copy Code
|
|---|
ISNA( Any x ) → Logical |
Parameters
- x
- Required. The value to test.
Remarks
If x is the #N/A error value, returns TRUE; if x is any of the other error values, or not an error value, returns FALSE. Note that this function does not propagate error values.
Example
| Formula
Copy Code
|
|---|
=ISNA(NA()) |
See Also
Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISLOGICAL Function
ISNONTEXT Function
ISREF Function
TYPE Function