Returns the first value if it isn’t an error, otherwise returns the second value.
IFERROR([Task Name]15, "Data needed")
- 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.
- 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.