IFERROR Function

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