Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Iserror-Function

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

Function 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

 Formulas:
  A B
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:
  A B
1   FALSE
2   FALSE
3   TRUE
4   TRUE
5   FALSE
6 #N/A TRUE
7   FALSE

In the examples above, the arguments to the Iserror function calls are:

For further details of the different types of Excel error messages, see the page on Excel Formula Errors.

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

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions