Syntax
ISERROR(value)- value
- The cell, value or formula to check.
Examples
E1=ISERROR(B2/C2)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | Visits | TRUE | |
| 2 | North | 500 | 0 | ||
| 3 | South | 300 | 60 |
E1=IF(ISERROR(B3/C3),0,B3/C3)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | Visits | 5 | |
| 2 | North | 500 | 0 | ||
| 3 | South | 300 | 60 |
E1=ISERROR(MATCH("West",A2:A3,0))
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | Visits | TRUE | |
| 2 | North | 500 | 0 | ||
| 3 | South | 300 | 60 |
Questions
Should I use ISERROR or IFERROR?
To replace an error with another value, IFERROR is shorter, since =IFERROR(B2/C2,0) does what IF and ISERROR do in two steps. Use ISERROR when you only need TRUE or FALSE, for example in conditional formatting.
Does ISERROR catch
Yes, it catches every error. ISNA catches only