Explanation of the IFERROR function
The IFERROR function has 2 arguments as shown below:
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.
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
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.