IFERROR Function

The IFERROR function is one of the logical functions. It is used to check if there is an error in the formula in the first argument. The function returns the result of the formula if there is no error, or the value_if_error if there is one.

Syntax

IFERROR(value, value_if_error)

The IFERROR function has the following arguments:

Argument	Description
value	The value that is checked for an error.
value_if_error	The value to be returned if the formula evaluates to an error. The following errors are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!.

Notes

How to apply the IFERROR function.

Examples

You have a list of available item stock and its overall value. To learn unit price, we will use the IFERROR function to see if there are any errors. The arguments are as follows: value = B2/A2, value_if_error = "Out of stock". The formula in the first argument does not contain any errors for cells C2:C9 and C11:C14 so the function returns the result of the calculation. However, it is the opposite for C10 and C11 since the formula tries to divide by zero, hence, we get "Out of stock" as a result.

Return to previous page