The IFERROR function returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula.

• This function was introduced in Excel 2007 and so is not available in earlier versions.

### Syntax

=IFERROR(value,value_if_error)

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

#### Arguments

Argument Description
value The argument that is checked for an error
value_if_error The value to return if the formula evaluates to an error. The following error types are evaluated:

 – #N/A – #NUM! – #VALUE! – #NAME? – #REF! – #NULL! – #DIV/0!

#### Examples

A B C D
1 Quota Units Sold
2 210 35
3 55 0
4   23
5
6 Formula Result Notes
7 =IFERROR(A2/B2,”Error in calc”) 6 Checks for an error in the formula in the first argument (divide 210 by 35), finds no error, and then returns the results of the formula
8 =IFERROR(A3/B3,”Error in calc”) Error in calc Checks for an error in the formula in the first argument (divide 55 by 0), finds a division by 0 error, and then returns value_if_error
9 =IFERROR(A4/B4,”Error in calc”) 0 Checks for an error in the formula in the first argument (divide “” by 23), finds no error, and then returns the results of the formula