# The Excel ISERR Function

Excel ISERR vs. ISERROR Functions

The Excel Iserr and Iserror 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
ISERROR
ISNA

## Function 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 Iserr function returns FALSE.

The syntax of the function is:

ISERR( value )

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

## Iserr Function Examples

Column B of the following spreadsheet shows examples of the Excel Iserr function.

Formulas:
AB
1 =ISERR( 559 )
2 =ISERR( #REF! )
3 =ISERR( #N/A )
4 =ISERR( 225/0 )
5 =ISERR( 225/5 )
6#N/A=ISERR( A6 )
7#VALUE!=ISERR( A7 )
8 =ISERR( A8 )
Results:
AB
1 FALSE
2 TRUE
3 FALSE
4 TRUE
5 FALSE
6#N/AFALSE
7#VALUE!TRUE
8 FALSE

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 further details on the different types of Excel error messages.

Also, see the Microsoft Office website for further information on the Excel 'Is' functions.