Basic Description

The Excel Iserror function tests if an initial supplied expression (or value) returns an Excel Error, and if so, returns the logical value TRUE; Otherwise the function returns FALSE.

The syntax of the function is:

Where the supplied value argument is either a directly supplied value, a result from a formula, or a cell reference, that you want to test.

Iserror Function Examples

The following spreadsheets show examples of the Excel Iserror function, used to determine whether a value or expression returns an error. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

In the examples above, the arguments to the Iserror function calls are :

• Simple values in cells B1 - B3
• Expressions in cells B4 & B5 (note the division by zero in cell B4 will produce the #DIV/0! error)
• Cell references in cells B6 & B7

For more details of the different types of Excel error messages, see the page on Excel Formula Errors.