The Excel ISERR Function

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

The syntax of the function is:

ISERR( value )

Where the supplied 'value' argument can be a simple value, a value returned from a formula, or a reference to a cell containing a value.


Iserr Function Examples

The spreadsheets below show 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 an explanation of the different types of Excel error messages.