=IFERROR(value, value_if_error)
Where “value” is the value or formula that you want to test for an error, and “value_if_error” is the value that you want to display if an error occurs.
For example:
=IFERROR(A1/B1, “Error”)
This formula divides the value in cell A1 by the value in cell B1 and returns the result. If an error occurs (e.g. division by zero), it returns the text “Error” instead of the error message.
As you can see in the example below, iferror formula returns the value if there’s an error in column I. However, column I calculates the average sold units price, and if sold units are 0 that means we need more sales and error pups up.