ISERR
Returns TRUE if the value is any error value except #N/A.
InformationError Handling & ChecksInformation & Auditing
What it does
Checks for any error EXCEPT #N/A.
Syntax
ISERR(value)
Arguments
value(value) — Value to check.
Examples
Check Error
Check #DIV/0!.
FORMULA
=ISERR(1/0)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Calc |
| 2 | #DIV/0! |