Monday 1 May 2017

Excel - Excel ISERROR vs ISERR Functions

Description


The Excel Iserror and Iserr Functions both test a value and return True or False depending on whether the value is an error or not.

However, the two functions differ in the following way:
The Iserror function returns True if the supplied value is any error;
The Iserr function returns True if the supplied value is any error except the #N/A error.


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 value argument is the expression or value to be tested.

Iserror Function Examples
Column B of the following spreadsheet shows several examples of the Excel Iserror function.

No comments:

Post a Comment