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.