The ISERROR function evaluates whether an expression returns an error and returns the logical value True in positive case and the logical value False in negative case.
Syntax
ISERROR(
value
)
Parameters
- value: Value to evaluate.
Returned value
The ISERROR function returns a Boolean.
Examples
This example evaluates the calculation (Sales 2016 - Sales 2015) / Sales 2015. If it returns an error, a Blank is displayed, otherwise the result of the calculation is displayed:
Although it could have been solved using the DIVIDE function, as stated, it serves to show how the ISERROR function works.
Category
Information
