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 Check A or Check B is checked ON, display "Checked" in Classification A. If not, display "Unchecked".
![image](https://pleasanter.org/binaries/2d9befbc69824e35860d4338e231f6e4)
### 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 Number B is more than 1000 yen, it is discounted by 90%, otherwise it is the regular price.
![image](https://pleasanter.org/binaries/e1621cfe49da49e7becdbc9cb9b888d1)
## Related Information
<div id="ManualList">
<article class="s-blog_list_unit"><h2>
<h2>The specified information was not found.</h2>
<p><a href="/ja/manual">Return to top</a></p>
</article>
</div><input id="SearchTextHidden" type="hidden" value="" />