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. The spreadsheet on the left shows the formulas used and the spreadsheet on the right shows the results.

 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.

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