The Excel ISERROR Function

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 supplied value argument is either a directly supplied value, a result from a formula, or a cell reference, that you want to test.


Iserror Function Examples

The following spreadsheets show examples of the Excel Iserror function, used to determine whether a value or expression returns an error. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 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 more details of the different types of Excel error messages, see the page on Excel Formula Errors.

Also, you can find more information and further examples of the Excel Iserror function on the Microsoft Office website.