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.


The Iserror Function In VBA

The Iserror function is also a built-in function in VBA (used for writing Excel Macros).

Within VBA, the function takes exactly the same format as when used in an Excel spreadsheet:

IsError( value )

For example:

Dim  A1Err  As Boolean
A1Err  =  IsError( Cells( 1, 1 ).Value )

After running the above 2 lines of VBA code, the variable 'A1Err' holds the value True if cell A1 of the current worksheet contains an error, and holds the value False otherwise.

Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net