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.


Description

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.


Syntax

The IFERROR function has the following syntax

=IFERROR(value, value_if_error)

Where

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


Example

Refer the figure below for examples on the IFERROR function

Figure

So, this is how you can use the IFERROR function to handle and trap errors in formulas in the Excel Application.



Read other Applications