## Overview Evaluate the first "[Logical Expression](/en/manual/formula-function-logical-expression)" and return the paired value if it is true. If it is false, evaluate the second "[Logical Expression](/en/manual/formula-function-logical-expression)" and return the paired value if it is true. This is repeated for each set of logical expressions and strings. ## Syntax ``` $IFS(Logical Expression 1, String 1, [Logical Expression 2, String 2],...) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Logical Expression 1|[Logical Expression](/en/manual/formula-function-logical-expression)|Required|| |String 1|Arbitrary String|Required|String to return if "Logical Expression 1" is true| |[Logical Expression 2]|[Logical Expression](/en/manual/formula-function-logical-expression)|Optional|| |[String 2]|Arbitrary String|Optional|String to return if "Logical Expression 2" is true| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Logical Expression 1|Yes*1|Yes*1|Yes*1|Yes*1|Yes| |String 1|Yes|Yes|Yes|Yes|No| |[Logical Expression 2]|Yes*1|Yes*1|Yes*1|Yes*1|Yes| |[String 2]|Yes|Yes|Yes|Yes|No| *1: Can be used as a variable to configure a "[Logical Expression](/en/manual/formula-function-logical-expression)". Example: NumA == 1000 DateA > DateB ClassA == "Text" ## Return Value String that is the pair of the logical expression that is true. It is judged from the left. An error occurs if all logical expressions are false. ### Return Value for Target Column |Target|Return value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the return value is a half-width numerical value and a drop-down list with values, display the options that match the return value. | |Numerical Value (including work volume, progression rate, remaining work volume)|Display return value only if the return value is a half-width numerical value. | |Date (including start and completion)|Display return value only if the return value is a string in date format. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula  ### Parameters  ### Calculation Result