The Excel ISERROR Function

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

Related Functions:  ERROR.TYPE function ISERR function ISNA function

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.

The Iserror Function In VBA

The Iserror function is also a built-in function in VBA (used for writing Excel Macros).

Within VBA, the function takes exactly the same format as when used in an Excel spreadsheet:

For example:

After running the above 2 lines of VBA code, the variable 'A1Err' holds the value True if cell A1 of the current worksheet contains an error, and holds the value False otherwise.