IFERROR Function

Returns the first value if it isn’t an error, otherwise returns the second value.
Sample Usage
IFERROR([Task Name]15, "Data needed")
Syntax
IFERROR(
  • 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.
Usage Notes
  • 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 re-evaluate the expression.
     
Examples

This example references the following sheet information:

Row #

Clothing Item

Item Number

Price Per Unit

Ship Date

1

T-Shirt

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