ISERROR function
ISERROR returns TRUE if a value is any error, including #N/A, and FALSE otherwise. It can hide real problems, so IFERROR or IFNA is often a better choice.
Example
Read it as a sentence: check whether F5 holds any kind of error, which gives TRUE.
Excel shows TRUE
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Syntax
ISERROR(value)
-
value(required) - The value to check.
Returns: TRUE if the value is any error.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISERROR(NA()) | TRUE | N/A |
=ISERROR(1/0) | TRUE | Div 0 |
=ISERROR("a") | FALSE | Text |
=ISERROR(Data!F5) | TRUE | Error cell |
=ISERROR(Data!F1) | FALSE | Blank |
=ISERROR(Data!F4:F5) | FALSE | Range spills |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Watch out for
- Hides real problems; IFERROR or IFNA is often better.
Where it works
- Excel
- ISERROR is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .