IFERROR

  • Updated

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

Sample Usage

IFERROR(C1,"Error in cell C1")
IFERROR(C1) 

Syntax

IFERROR(value, value_if_error)

  • value - The argument that is checked for an error.
  • value_if_error - [OPTIONAL] The text to display in the cell as the link or a reference to a cell containing the label.

Examples

IFERROR(C1,"Error in cell C1") returns the value of C1 if there is no error. If there is an error, it returns the string: "Error in cell C1".