ISERROR
Return TRUE when a formula produced any error.
Syntax
ISERROR(value)| Argument | Required | Description |
|---|---|---|
value | Required | The value or formula to test. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=ISERROR(1/0) | TRUE | |
=ISERROR(A1) | FALSE | |
=ISERROR(VLOOKUP(999,A1:B1,2,FALSE)) | TRUE |
Prefer IFERROR when you are going to substitute
IF(ISERROR(x), 0, x) evaluates x twice — once to test it and once to return
it. On an expensive lookup that is double the work, and on a volatile formula the
two evaluations can disagree.
IFERROR does it in one pass:
=IFERROR(x, 0)ISERROR is for when you want the answer to be a yes or no — counting broken
rows, flagging them for review — rather than replacing the value.
It catches everything
Every error type, including the #REF! that means your range is broken. When
you only mean “not found”, ISNA is the narrower and safer
test.
Excel compatibility
Matches Excel — TRUE for every error type.