The IFERROR Function Knowledgebase In Excel

Quantunet.com

My Account

Joins Us

Excel QuickSkills

The IFERROR() Function Knowledgebase

The IFERROR() function tests for an error in the submitted value. If Excel recognizes and error it will respond by returning a specified value to the cell.

The syntax for the function is IFERROR (value, value_if _error).

Where "value" represents a formula or condition to be tested by the function, "value_if_error" is a "programmed" response to the error check which can be a number, a text string or.

How to use the IFERROR() function:

Type " =IFERROR( "
Enter the coordinate of the data cell "A2"
Type a comma.
Enter the response for when the condition is not met "2".
Type a ")" then press the "Enter" key.

Alerting and controling division errors.

Note: If no argument is entered for the "value_If_false" value the function will return a value of zero to the cell when the tested condition is not met. e.g. IF(A2=B2, 2) = 0when A2 is not equal to B2.