Logical Expression Used in Formula (Extended) Function
## Overview
This section explains the logical expressions used in the "[Formula (Extended)](/en/manual/table-management-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](/en/manual/formula-function-and)" and "[$OR Function](/en/manual/formula-function-or)".
**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"><ul><li><a href="/en/manual/table-management-formula-extended">Manage Table: Formula (Extended)</a><span>10.03.2024 up</span></li>
<li><a href="/en/manual/formula-function-and">Formula (Extended): $AND Function</a><span>10.03.2024 up</span></li>
<li><a href="/en/manual/formula-function-or">Formula (Extended): $OR Function</a><span>10.03.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />