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