### Explanation of the IFERROR function

The IFERROR function has 2 arguments as shown below:

- value
- value_if_error

You can use other Excel functions within both of the arguments as well.

**Note:** I typically use the IFERROR to clean up the results of my formulas if they return an ERROR. I do this by setting the **value_if_error** to a blank value with 2 quotations side by side “” but your **value_if_error** can be anything you choose.

#### 1. value

This is the value that the IFERROR function will use to determine if the value is an ERROR:

- If the
**value**is an error, it will return the result of the**value_if_error** - If the
**value**is not an error, it will return the result of the**value**

#### 2. value_if_error

This is what you want Excel to do if your **value** is an error. Some examples include:

- Return a blank value by using 2 quotations side by side “”
- Write a
**vlookup**to bring a value from somewhere - Use any Excel function or combination of functions to evaluate for a result
- Perform a mathematical calculation
- Return a fixed result (number or text)

### Examples of when to use an IFERROR function

**VLOOKUP**function that doesn’t find your lookup value and returns an #N/A error- Dividing by 0 (zero) and returns a #DIV/0! error

I will cover the 2 examples above, but you can use the IFERROR function for any other errors or scenarios you are dealing with.

**IFERROR with VLOOKUP**

In the example below I am looking for 2 names (1 which exists in my data and 1 that does not) and forcing the result of the error to “Not Found” when the VLOOKUP function returns an error.

**Note:** I used an **absolute reference** (using $ sign) for my lookup_range in the VLOOKUP formula below.

**IFERROR with mathematical calculations (divide by zero)**

In the example below I am forcing the error to show as a blank value, or else it will return the result of the division (if no error).

#### Go back to **Excel Tutorials**.