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