Description
ISERR 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 ISERR if the referred cell contains an error (other than #NA error), it means the condition is met and the TRUE result will be returned. Similarly, if the value is referred cell is not an error OR #NA error, Excel will return “FALSE” as a result.
On the other hand, the ISERROR function can be used instead of the ISERR function, as it returns “TRUE” if there is any error (including #NA).
=ISERR(value)
The ISERR function’s syntax has the following argument:
- value Required
The value is the cell reference that you want to test against the condition if the cell contains an error (other than #NA error). The value argument can be a blank (empty cell), error, logical value, number, or reference value, etc.
