The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISERROR Function
Syntax
=ISERROR(value)
Checks if the value, reference or formula returns an error.
Returns TRUE or FALSE
Refers to any error message: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
Examples
| A | B | C | D | E | F | G |
| 2 | ||||||
| 3 | Cell references | Returned Values | ||||
| 4 | =K14*#REF! | =ISERROR(D4) | TRUE | |||
| 5 | =+BogusRangeName | =ISERROR(D5) | TRUE | |||
| 6 | cell D6 is blank | =ISERROR(D6) | FALSE | |||
| 7 | 100 | 100 | =+B7=C7 | =ISERROR(D7) | FALSE | |
| 8 | #DIV/0 | =ISERROR(D8) | TRUE | |||
| 9 | Formulas | |||||
| 10 | 12 | 0 | =ISERROR(B11/D11) | TRUE | ||
| 11 | 12 | abc | =ISERROR(B12*C12) | TRUE | ||
| 12 | 12 | 2 | =ISERROR(B13/D13) | FALSE |
Categories: IS Functions