This formula will return a specified value if your given expression results in an error.

## Syntax

**IFERROR(**E*xpression*, Value if error)

**Expression**(*required*) – This is part of the formula that is checked for an error.**Value if error**(*required*) – This is the value that is returned if the expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!).

## Example

In this example we want to calculate an average cost per use = cost / # of uses (=A2/B2), however some of the # of uses are 0 and this results in a #DIV/0 error.

We can use the IFERROR function to set the average to 0 when we get a #DIV/0 error by using IFERROR(A2/B2,0).