Calc IFERROR function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the IFERROR function.

Description

Returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

Syntax

IFERROR(value, value_if_error)

• value - Required. The argument to check for an error.
• value_if_error - Required. The value to return if value is an error.

Remarks

• If value is not an error, IFERROR returns the result of value.
• If value is an error, IFERROR returns value_if_error.
• IFERROR will catch all errors except for #N/A errors. If you want to catch #N/A errors, use the IFNA function instead.

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc IFNA function
• Calc IFNULL function
• Calc ISEVEN function
• Calc ISIMAGE function
• Calc ISNUMBER function