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

The following spreadsheets show 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:

For more 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.