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