Excel FunctionsExcel ISERROR Function

Using Iserror function

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.

AVANTAGEHeadquarters
Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
https://excel-accountancy.com/wp-content/uploads/2019/04/img-footer-map.png
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.