Excel FunctionsExcel ISERROR Function

Using Iserror function


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. 


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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.