Formula (Advanced): $IFERROR Function
Overview¶
Return the specified value if the value is an error. If it is not an error, return the value.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Value | Formula | Required | Value, formula, or formula to check for error |
| Value if error | Formula | Required | Value, formula, or formula to return if the first argument "value" is an error |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Value | Yes | Yes | Yes | Yes | Yes |
| Value if error | Yes | Yes | Yes | Yes | Yes |
Return Value¶
If the value is an error, return the "value if error". Otherwise, return the "value".
Return Value for Target Column¶
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. If the return value is a half-width numerical value and is a drop-down list with values, display the options that match the return value |
| Numerical Value (including work volume, progression rate, remaining work volume) | Display return value only if the return value is a half-width numerical value. |
| Date (including start and completion) | Display return value only if the return value is in date format. |
| Description (including content) | Display return value. |
| Check (including lock) | Check ON if the return value is true, check OFF if the return value is false |
Usage Example ①¶
Specify parameters by screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
Usage Example ②¶
Combination with other functions
Formula¶
Parameters¶
Calculation Result¶
