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".