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

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

See the Excel Formula Errors page for further details on the different types of Excel error messages.

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