Logical Expression Used in Formula (Extended) Function
Overview¶
This section explains the logical expressions used in the "Formula (Extended)" function. Logical expressions are used for conditional judgments such as the "$IF Function".
1. Use Logical Functions¶
Use logical functions such as the "$AND Function" and "$OR Function".
Setting Example
If either CheckA or CheckB is checked ON, display "Checked" in ClassA. If not, display "Unchecked".
2. Description Using JavaScript's Comparison Operators¶
The following comparison operators can be used in the description.
| Operator | Description | Example of true return |
|---|---|---|
| == (equal) | Return true if the left side and right side are equal | ClassA == "Nakano Ward" |
| != (not equal) | Return true if the left side and right side are not equal | ClassA != "Nakano Ward" |
| > (greater than) | Return true if the left side is greater than the right side | NumA > 1000 |
| >= (greater than or equal to) | Return true if the left side is greater than or equal to the right side | NumA >= 1000 |
| < (less than) | Return true if the left side is less than the right side | NumA < 1000 |
| <= (less than or equal to) | Return true if the left side is less than or equal to the right side | NumA <= 1000 |
Setting Example
If NumB is more than 1000 yen, it is discounted by 90%, otherwise it is the regular price.
