In Excel there are many common functions, including the IFERROR function. If you are learning the syntax of the IFERROR function as well as want to see an example to understand how to apply, please refer to the following article.
In addition to the Excel IFERROR function , fix errors in Excel formulas. Readers can refer to some articles available on Software to learn about the SWITCH function and the AVERAGE function in Excel.
Excel IFERROR function
Description of the Excel IFERROR function, correcting errors in Excel formulas
The Excel IFERROR function takes 2 values (or expressions) and checks, if:
– If the first value provided does not evaluate the error, the result returned will be this value.
– If the first value provided evaluates the error, the result returned is the 2nd value provided.
The Excel IFERROR function syntax looks like this:
IFERROR( value, value_if_error )
Where:
Value: The first value or expression that needs to be checked.
– Value_if_error: The alternate value, or expression, returned joins the supplied value argument that returns an error.
Note: The Iferror function is new to Excel 2007, so it is not available in earlier versions of Excel.
Example of Excel IFERROR function, correcting errors in Excel formulas
Example 1
The spreadsheet below illustrates the Excel Iferror function.
Formula:
The result returns:
Note:
– In the first example (in cell C1), the value argument, A1/B1 returns the value 0.5. It 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 an error #DIV/0!. So the Iferror function returns argument value_if_error, which is 0.
Example 2
In the spreadsheet below, the Excel Iferror function is used with the Vlookup function.
Formula:
The result returns:
If the Vlookup function successfully looks up the value, it is displayed in the cell. Otherwise, the message “not found” will be displayed.
https://thuthuat.taimienphi.vn/ham-iferror-trong-excel-34349n.aspx
Above is some information and examples of the IFERROR function in Excel, correcting errors in Excel formulas. In addition, readers can visit the Microsoft homepage to learn some more examples of IFERROR functions in Excel. The IF function in Excel is also a function that is used a lot in each problem, The IF function is a function that takes the value according to a given condition.