ExcelFunctions.net Logo

The Excel ISERROR Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Iserror-Function
Search this site:
Custom Search
Related Functions: 

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 :

  • Simple values in cells B1 - B3
  • Expressions in cells B4 & B5 (note the division by zero in cell B4 will produce the #DIV/0! error)
  • Cell references in cells B6 & B7

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.





Valid XHTML 1.0 Transitional
Disclaimer Privacy Policy

Copyright © 2008-2011 ExcelFunctions.net