Excel has many common functions, including the IFERROR function. If you are looking to understand the syntax of the IFERROR function and want to see illustrative examples to understand how to apply it, please refer to the following article.
Besides the IFERROR function in Excel for fixing errors in Excel formulas, readers can refer to some articles already available on TipsMake to learn about the SWITCH and AVERAGE functions in Excel.
The IFERROR function in Excel
Description of the IFERROR function in Excel, fixing errors in Excel formulas.
The IFERROR function in Excel takes two values (or expressions) and checks if:
- If the first value provided does not evaluate to an error, the result will be that value.
- If the first value provided evaluates to an error, the result will be the second value provided.
The syntax for the IFERROR function in Excel is as follows:
IFERROR( value, value_if_error )
Where:
- Value : The first value or expression to be checked.
- Value_if_error : The alternative value or expression, returned by concatenating the provided value argument, which returns an error.
Note: The IfError function is new in Excel 2007, so it is not available in earlier versions of Excel.
For example, the IFERROR function in Excel, corrects errors in Excel formulas.
Example 1:
The spreadsheet below illustrates the IfError function in Excel.
Formula:
The result returned:
Note:
- In the first example (in cell C1), the value argument, A1/B1, returns 0.5. This is not an error, so this value is returned by the IfError function.
- In the second example (in cell C2), the value argument, A2/B2, returns the error #DIV/0!. Therefore, the IfError function returns the value_if_error argument, which is 0.
Example 2:
In the spreadsheet below, the IfError function in Excel is used with the Vlookup function.
Formula:
The result returned:
If the Vlookup function successfully retrieves a value, it will be displayed in the cell. Otherwise, a "not found" message will be displayed.
Above is some information and examples of the IFERROR function in Excel, used to correct errors in Excel formulas. Additionally, readers can visit the Microsoft website to find more examples of the IFERROR function in Excel. The IF function in Excel is also frequently used in various problems; it retrieves a value based on a given condition.