Conditional

Use a Conditional expression type to specify an if-then-else statement, which returns a value when a condition evaluates to true or returns a different value when the condition evaluates to false.

The parameters are: condition=(). For example, to return "Cash" when the account value is "1100", or "ShortTermRec " when the account value is 1300-101, or "AccruedTax" when the account value is 1300-102, or "No Member" when the account value is null or equals "", use the following expression:

if (ACCOUNT == "1100") return "Cash"
         
else if (ACCOUNT == "1300-1else return Liability 01") return "ShortTermRec"
         
else if (ACCOUNT == "1300-102") return "AccruedTax" 
         
// if then with or/and
if (ACCOUNT == null or ACCOUNT == "") return "No Member"