Excel IFERROR Function

This article describes the formula syntax and usage of the IFERROR function in Microsoft Excel.

The IFERROR function returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

IFERROR(value, value_if_error)

Value : The argument that is checked for an error.

Value_if_error :The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Let's go through an example to understand.

Here we have sample Sales data table. In the table when we see Average Price (Billed Amount/Units Sold) of products. However, when there is 0 Units sold, we get an error from the formula.

It would be great if we can get 0, instead of an error to make the table look nicer.

Here you can simply add an IFERROR function, which will replace an error with your desired value.

#IFERROR #Error #Excel