Formula (Extended): $ISERROR Function
Overview¶
Return true if the argument is an error.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Value | Formula | Required | Value, formula, or formula to check for error |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Value | Yes | Yes | Yes | Yes | Yes |
Return Value¶
True if an error occurs. False, Otherwise.
Return Value for Target Column¶
| Target | Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display the string "True" or "False" |
| Numerical Value (including work volume, progression rate, remaining work volume) | Do not display |
| Date (including start and completion) | Do not display |
| Description (including content) | Display the string "True" or "False" |
| Check (including lock) | Check ON if true, check OFF if false |
Usage Example ①¶
Specify parameters by screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
