This is a discussion on The Logical function IFERROR in Microsoft Excel 2010 within the Applications forums, part of the Tutorials category; The Logical function IFERROR in Microsoft Excel 2010 After going through the following tutorial, you will be familiarized with the ...
The Logical function IFERROR in Microsoft Excel 2010
After going through the following tutorial, you will be familiarized with the usage and the syntax of the IFERROR logical function that is present in Excel application.
The IFERROR function when entered along with a formula returns a value that you specify if the formula evaluates to an error; otherwise it returns the actual result of the formula. You can make use of the IFERROR function to handle and Trap errors in formulas in Excel application.
The IFERROR function has the following syntax
‘value’ is the argument or the condition that you want to check for errors.
‘value_if_error’ is the value that you specify and want to be returned if the formula evaluates to an error. The following types of errors are evaluated: #NUM!, #NAME!, #REF!, #N/A, #VALUE! or #NULL!.
NOTE: - if the value_if_error’ argument is omitted or empty, the IFEREROR function returns an empty string value (,,,). If the value argument is an array formula, the function returns an array of results for each cell that is specified in the value argument.
Refer the figure below for examples on the IFERROR function
So, this is how you can use the IFERROR function to handle and trap errors in formulas in the Excel Application.
Read other Applications
Last edited by jagadish; 09-21-2010 at 12:17 PM.