ISERROR Function

Checks for a calculation error within another formula.
Sample Usage
IF(ISERROR([Task Name]15), "There's a calculation error")
  • value
  • value
    The value, typically a formula, to test for an error.
Usage Notes
  • This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.
  • A good alternative to the ISERROR function is IFERROR, which does not require nesting. 
Was this article helpful?