Formula (Extended): $IF Function
Overview¶
Return a specified value depending on the result of a "Logical Expression" (true or false).
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Logical Expression | Logical Expression | Required | |
| Formula 1 | Formula | Required | Formula to execute if Logical Expression is true |
| Formula 2 | Formula | Required | Formula to execute if Logical Expression is false |
Column Usable as Parameters¶
| Parameter | Classification | Numeric Value | Date | Description | Check |
|---|---|---|---|---|---|
| Logical Expression | Yes*1 | Yes*1 | Yes*1 | Yes*1 | Yes |
| Formula 1 | Yes | Yes | Yes | Yes | Yes |
| Formula 2 | Yes | Yes | Yes | Yes | Yes |
*1: Can be used as a variable to configure "Logical Expression".
Example:
NumA == 1000
DateA > DateB
ClassA == "Text"
Return Value¶
If the logical expression is true, the result of formula 1 is returned, and if it is false, the result of formula 2 is returned.
Return Value Display Content¶
| Target | Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display the string "True" or "False" |
| Numeric 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¶
Usage Example ②¶
Calculate the value of 70% discount when the value of ClassA is "discount"
Formula¶
Parameters¶
Calculation Result¶
