- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Information - ISERROR Function
Description
The ISERROR function returns the logical value TRUE if the value refers to an Excel Error. Otherwise returns FALSE.
Syntax
ISERROR (value)
Arguments
Argument | Description | Required/Optional |
---|---|---|
value | An error | Required |
Notes
This function is useful in formulas for testing the outcome of a calculation. When combined with the IF Function, this Function provides a method for locating errors in formulas
Both ISERR and ISERROR functions test a value and return True or False depending on whether the value is an error or not. The only difference is −
The ISERROR function returns True if value is any error.
The ISERR function returns True if value is any error except the #N/A error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_information_functions.htm
Advertisements