Description
ISERROR Function is a conditional function that returns either TRUE or FALSE as result. Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
In ISERROR if the referred cell contains any error (including #NA Error), it means the condition is met and the TRUE result will be returned. Similarly, if the value in the referred cell is not an Error, Excel will return “FALSE” as a result.
Unlike the ISERR function, the ISERROR function also returns the TRUE value for cells containing #NA error.
=ISERROR(value)
The ISERROR function’s syntax has the following argument:
- value Required
The value that you want to be tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.
