
value

value_if_error
 value—The value, typically a formula, to test for an error.
 value_if_error—The value or formula to return if the first value results in an error.
 This function does not suppress errors caused by improperly constructed formulas.
 This is similar to nesting the ISERROR function within an IF function; however, with IFERROR you don't have to retype or reevaluate the expression.
This example references the following sheet information:
Row # 
Clothing Item 
Item Number 
Price Per Unit 
Ship Date 

1 
TShirt 
C001 
$15.00 
03/05/19 
2 
Pants 
C002 
$35.50 
03/20/19 
3 
Jacket 
C003 
$200.00 
02/27/19 
4 
Jacket 
C003 
#DIVIDE BY ZERO 
02/27/19 
Given the table above, here are some examples of using IFERROR in a sheet:
Formula 
Description 
Result 

=IFERROR(SUM([Price Per Unit]:[Price Per Unit]), "There is an Error in Price") 
SUM the “Price Per Unit” column, if there is an error produce the value "There is an Error in Price". 
There is an Error in Price 
=COUNTIF([Ship Date]:[Ship Date], IFERROR(MONTH(@cell) = 3, " ")) 
COUNT the values in the “Ship Date” column, if the month’s cell value equals 3 (March), If there is an error in the criteria produce a blank value. Row 2 and 3 of the Ship Date column meet the criteria. 
2 
=IFERROR(VLOOKUP("Jacket", [Clothing Item]:[Item Number], 2, false), " ") 
Look up the value “Jacket” in the “Clothing Item” column, if found, produce the value in the “Item Number” column. If there is an error, such as a #No Match, produce a blank value. 
C003 