The Excel ISERR Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Iserr-Function Search this site: Custom Search

Related Functions:  ERROR.TYPE function ISERROR function ISNA function

Basic Description

The Excel Iserr function tests if an initial supplied expression (or value) returns any Excel Error, except the #N/A error. If so, the function returns the logical value TRUE; If the supplied value is not an error or is the #N/A error, the function returns FALSE.

The syntax of the function is:

Where the supplied 'value' argument can be a simple value, a value returned from a formula, or a reference to a cell containing a value.

Iserr Function Examples

The spreadsheets below show examples of the Excel Iserr function. The spreadsheet on the left shows the formulas used and the spreadsheet on the right shows the results.

In the above examples, the arguments supplied to the Iserr function are :

• Simple values in cells B1 - B3
• Values returned from formulas, in cells B4 & B5 (note the division by zero in cell B4 will produce the #DIV/0! error)
• Cell references in cells B6 - B8

See the Excel Formula Errors page for an explanation of the different types of Excel error messages.