Description
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.
=IFERROR(VALUE,value_if_error)
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!.
