Wednesday 3 May 2017

Excel - The Excel Iserr function

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 Iserr function returns FALSE.
The syntax of the function is:
ISERR( value )
Where the value argument is the expression or value to be tested.

Iserr Function Examples

Column B of the following spreadsheet shows several examples of the Excel Iserr function.
In the above examples, the arguments supplied to the Iserr function are:

No comments:

Post a Comment