User Manual

10.03.2024

MANUAL

Formula (Extended): $AND Function

## Overview Return true if all arguments are true. ## Syntax ``` $AND(Logical Expression 1, [Logical Expression 2], ...) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Logical Expression 1|[Logical Expression](/en/manual/formula-function-logical-expression)|Required|| |[Logical Expression 2], ...|[Logical Expression](/en/manual/formula-function-logical-expression)|Optional|| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Logical Expression 1|Yest*1|Yes*1|Yes*1|Yes*1|Yes| *1: Can be used as a variable to configure the "[Logical Expression](/en/manual/formula-function-logical-expression)". Example: NumA == 1000 DateA > DateB ClassA == "Text" ## Return Value True if all arguments are true. Fales, otherwise. ### Return Value for Target Column |Target|Return value| |:---|:---| |Classification (including title, status, manager, owner)|Display the string "True" or "False"| |Numerical Value (including work volume, progression rate, remaining work volume)|Do not display| |Date (including start and completion)|Do not display| |Description (including content)|Displays the string "True" or "False"| |Check (including lock)|Check ON if true, check OFF if false| ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/efb7466ccdd24a37bf3ad02a0a67a268) ### Parameters ![image](https://pleasanter.org/binaries/0e89c77458ba468388a271f3cb83351e) ### Calculation Result ![image](https://pleasanter.org/binaries/5b242b777ab048a58c9b22bf8de5934e) ## Usage Example ② Set multiple parameters ### Calculation formula ![image](https://pleasanter.org/binaries/b261fcd8f10f4364ad8dd92985545152) ### Parameters ![image](https://pleasanter.org/binaries/87ed367a5f3b4e058980bdcda4a2d1e8) ### Calculation Result ![image](https://pleasanter.org/binaries/36828a42948a4f55890bfc0bef7ad10b)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.