Home » Excel-Built-In-Functions » Excel-Iserr-Function

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 TRUE; If the supplied value is not an error OR is the #N/A error, the function returns FALSE.

The format of the ISERR function is :

Where the Value argument can be a simple value, a formula or a cell reference.

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 examples above, The arguments to the ISERR 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 - B8

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