## Overview Return a specified value depending on the result of a "[Logical Expression](/en/manual/formula-function-logical-expression)" (true or false). ## Syntax ``` $IF(Logical Expression, Formula 1, Formula 2) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Logical Expression|[Logical Expression](/en/manual/formula-function-logical-expression)|Required|| |Formula 1|Formula|Required|Formula to execute if [Logical Expression](/en/manual/formula-function-logical-expression) is true| |Formula 2|Formula|Required|Formula to execute if [Logical Expression](/en/manual/formula-function-logical-expression) is false| ### Column Usable as Parameters |Parameter|Classification|Numeric Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Logical Expression|Yes*1|Yes*1|Yes*1|Yes*1|Yes| |Formula 1|Yes|Yes|Yes|Yes|Yes| |Formula 2|Yes|Yes|Yes|Yes|Yes| *1: Can be used as a variable to configure "[Logical Expression](/en/manual/formula-function-logical-expression)". Example: NumA == 1000 DateA > DateB ClassA == "Text" ## Return Value If the logical expression is true, the result of formula 1 is returned, and if it is false, the result of formula 2 is returned. ### Return Value Display Content |Target|Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display the string "True" or "False"| |Numeric Value (including work volume, progression rate, remaining work volume)|Do not display| |Date (including start and completion)|Do not display| |Description (including content)|Display 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  ### Parameters  ### Calculation Result  ## Usage Example ② Calculate the value of 70% discount when the value of ClassA is "discount" ### Formula  ### Parameters  ### Calculation Result