Checks for a calculation error within another formula.
Sample Usage
IF(ISERROR([Task Name]15), "There's a calculation error")
Syntax
ISERROR(
-
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.