ISERR
Description
If the specified value or expression results in an error, except for the #N/A error, returns TRUE; otherwise, returns FALSE.
Syntax
ISERR(
value
)
- value: The value or expression to evaluate.
Example
Formula | Result |
|---|---|
=ISERR(123) | FALSE |
=ISERR("phrase") | FALSE |
=ISERR(12/0) | TRUE |
=ISERR(A1) where A1 contains #N/A | FALSE |