IFERROR

Syntax:

IFERROR ( value , value-if-error )

Description: Provides a simpler and more efficient way of trapping and handling errors. It allows the generation of user-defined error text for a function call that can result in an error.

Arguments:

Name

Type

Description

value

any

The value that is checked for an error (i.e., any of the following: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). If value is an empty cell, it is treated as an empty string.

value-if-error

any

The value to return if value evaluates to an error. If value-if-error is an empty cell, it is treated as an empty string.

Return Type and Value: any – value, if value is not an error; otherwise, value-if-error. If value is an array formula, an array of results for each cell in the range specified in value, is returned.

example:

IFERROR(A3/B3,"Error in calculation") results in Error in calculation]