# Excel IFERROR Function

The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.

**value**- The value, reference, or formula to check for an error.**value_if_error**- The value to return if an error is found.

The IFERROR function "catches" errors in a formula and returns an alternative result or formula when an error is detected.

Use the IFERROR function to trap and handle errors produced by other formulas or functions. IFERROR checks for the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

### Example #1

For example, if A1 contains 10, B1 is blank, and C1 contains the formula =A1/B1, the following formula will catch the #DIV/0! error that results from dividing A1 by B1:

=IFERROR (A1/B1,"Please enter a value in B1")

As long as B1 is empty, C1 will display the message "Please enter a value in B1" if B1 is blank or zero. When a number is entered in B1, the formula will return the result of A1/B1.

### Example #2

You can also use the IFERROR function to catch the #N/A error thrown by VLOOKUP when a lookup value isn't found. The syntax looks like this:

In this example, when VLOOKUP returns a result, IFERROR functions that result. If VLOOKUP returns #N/A error because a lookup value isn't found, IFERROR returns "Not Found".

### Notes

- If
**value**is empty, it is evaluated as an empty string ("") and not an error. - If
**value_if_error**is supplied as an empty string (""), no message is displayed when an error is detected. - If IFERROR is entered as an array formula, it returns an array of results with one item for each cell in
**value**. - In Excel 2013+, you can use the IFNA function to trap and handle #N/A errors specifically.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.