# ​​​​Iferror

Checks if the value given as first argument is any type of error. If it is an error, the second argument is used as value. If it is not an error, the cell will be filled with the value given as first argument.

## Iferror syntax

=IFERROR(`Value`, `Value if error`)

### Try it for yourself

When calculating ratios, you may not want to show errors when dividing by 0. Try it out for yourself below.

Note that cell C3 in the spreadsheet below would normally contain a division by 0 error.

## Explanation

Calculating the ratio between two things requires dividing the two things. In this case, dividing the number of chairs by the number of people to get the chairs per person ratio. If we have 0 people, we end up dividing by 0. Dividing by 0 is not allowed in mathematics, so Excel shows an error.

Then, we use IFERROR to change the value of the cell to 0 if this error is shown. This way, the errors will not perpetuate throughout the workbook.

## Questions

Is there an IFNOTERROR function?

No, there is not. However, you could copy the formula in the answer below to accomplish the same thing.

Can I change the value if it isn’t an error?

Yes, although there is no function in Excel to do this, you can create your own formula. You could use something like:
`=IF(ISERROR(A1), "Error detected", "No error here")`
This formula checks cell A1 for errors. If there is an error, the value will be “Error detected”. If there is no error, the value will be “No error here”. We have also made an IFNOTERROR exercise, where you can try this for yourself.

What error values are checked by IFERROR?

#DIV/0, #N/A, #REF, #VALUE, #NUM, #NAME and #NULL.