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