Excel IFERROR Function


Excel IFERROR Function is a logical function. 

IFERROR function works based on IF logical statement.

If a logical statement meets the required criteria, then a specific value is returned, otherwise, the other given value is returned.

Similarly, in Excel IFERROR Function, if the required criteria i.e. the referred cell contain ERROR, is met, this function returns the specified value, otherwise, the value of the referred cell is returned.   


The Excel IFERROR function’s syntax has the following arguments:

  • Value Required.

This shall be an argument that is being tested against the required criteria i.e. if the argument is an error.

  • value_if_error Required.

The specified value to return if the argument referred is an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME, or #NULL!.

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.