# 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.

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!.

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")

In this case, C1 will display the message "Please enter a value in B1" if B1 is blank or zero.

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

When VLOOKUP returns a result, IFERROR functions that result. If VLOOKUP returns #N/A, 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**.

## Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!