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