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