ISERR function
ISERR returns TRUE for any error value except #N/A, and FALSE for everything else, including #N/A. Use ISERROR if you want #N/A to count as an error too.
Example
Read it as a sentence: check whether F11 holds an error other than #N/A, which gives FALSE.
Excel shows FALSE
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
6
Hello World
7
0
8
=""
9
abc
10
12.5
11
=NA()
Data
Syntax
ISERR(value)
-
value(required) - The value to check.
Returns: TRUE for any error except #N/A.
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 |
|---|---|---|
=ISERR(NA()) | FALSE | N/A |
=ISERR(1/0) | TRUE | Div 0 |
=ISERR(5) | FALSE | Value |
=ISERR(Data!F11) | FALSE | N/A cell |
=ISERR(Data!F5:F6) | TRUE | 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
6
Hello World
7
0
8
=""
9
abc
10
12.5
11
=NA()
Data
Watch out for
- #N/A returns FALSE here.
Where it works
- Excel
- ISERR 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 .