ISNA
Returns TRUE if the value is the #N/A error value.
InformationError Handling & ChecksInformation & Auditing
What it does
Checks specifically for #N/A error.
Syntax
ISNA(value)
Arguments
value(value) — Value to check.
Examples
Check NA
Check #N/A.
FORMULA
=ISNA(NA())
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | #N/A |