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:
 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 an explanation of the different types of Excel error messages.