You can use the `IFERROR`

function to catch errors in Excel. Using the function's parameters, you can return a custom value when specific errors occur.

In this article, you'll learn how to use the `IFERROR`

function to evaluate and handle errors in Excel. You can use the `IFERROR`

function to handle `#N/A`

, `#VALUE!`

, `#REF!`

, `#DIV/0!`

, `#NUM!`

, `#NAME?`

, or `#NULL!`

errors.

## IFERROR Function Syntax in Excel

Here's what the syntax for the the `IFERROR`

function looks like:

`IFERROR(value, value_if_error)`

As you can see above, the `IFERROR`

function has two parameters: `value`

and `value_if_error`

.

`value`

denotes the value to be checked for an error.`value_if_error`

is returned if the value checked throws an error.

The parameters above will make more sense with the examples that follow.

## How to Use the `IFERROR`

Function in Excel

In this section, you'll see a practical application of the the `IFERROR`

function.

Here's the table we'll be working with:

In the table above, we have three columns: **Data 1**,** Data 2**, and **Quotient**.

The idea here is to fill the third column (**Quotient**) with the result gotten from dividing **Data 1 **by** Data 2. **

That is:

For row one: 80/192

For row two: 75/180. And so on.

But if you look closely, some rows have values that will lead to mathematical errors — row 4 and row 6.

We cannot divide 60 by 0 on row 4, nor can we divide 65 by NIL on row 6.

Here's what the table will look like after the divisions:

The quotient for column 4 and 6 are `#DIV/0!`

and `#VALUE!`

, respectively. This is because the operation being performed leads to a math error.

We cannot fix this mathematically, but we can catch errors like these and return a custom value for them. Here's how using the `IFERROR`

function:

I've removed every value in the **Quotient **column. Next, we'll use the `IFERROR`

function. That is:

In the first **Quotient **row, we wrote the `IFERROR`

function: `=IFERROR(A2/B2, 0)`

. The two parameters are **A2/B2 **and **0**.

The first parameter **A2/B2** denotes **A2 **(80)** **divided by row **B2 **(192). If the division is possible, the quotient will be returned.

If the division is not possible, the second parameter (**0**) will be returned.

So our table will look like this after the `IFERROR`

function is applied in each row:

Now row 4 and 6 have 0 as their quotient instead of `#DIV/0!`

and `#VALUE!`

, respectively.

Note that you can use a custom message as well instead of 0. That is: `=IFERROR(A2/B2, "Division not possible")`

. You have to nest the text in quotation marks. We'll have a table like this:

So it's up to you to customize what will be returned if there is an error.

## Summary

In this article, we talked about the `IFERROR`

function in Excel. It can be used to handle `#N/A`

, `#VALUE!`

, `#REF!`

, `#DIV/0!`

, `#NUM!`

, `#NAME?`

, or `#NULL!`

errors.

We saw the syntax for using the `IFERROR`

function and the meaning of its parameters.

We also saw some examples that showed how to use the `IFERROR`

function in an Excel table.

Thank you for reading!