User Manual

08.13.2024

MANUAL

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="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.