Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

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.

IFERROR Function: if error

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action