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

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