# The Excel ISERROR Function

Excel ISERROR vs. ISERR Functions

The Excel Iserror and Iserr Functions both test a value and return True or False depending on whether the value is an error or not.

However, the two functions differ in the following way:

• The Iserror function returns True if the supplied value is any error;
• The Iserr function returns True if the supplied value is any error except the #N/A error.
Related Functions:
ERROR.TYPE
ISERR
IFERROR

## 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:

ISERROR( value )

Where the value argument is the expression or value to be tested.

## Iserror Function Examples

Column B of the following spreadsheet shows several examples of the Excel Iserror function.

Formulas:
AB
1 =ISERROR( 559 )
2 =ISERROR( "text" )
3 =ISERROR( #N/A )
4 =ISERROR( 225/0 )
5 =ISERROR( 225/5 )
6#N/A=ISERROR( A6 )
7 =ISERROR( A7 )
Results:
AB
1 FALSE
2 FALSE
3 TRUE
4 TRUE
5 FALSE
6#N/ATRUE
7 FALSE

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 further details of the different types of Excel error messages, see the page on Excel Formula Errors.

Also, further information on the Excel 'Is' functions is provided on the Microsoft Office website.