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