IF( AND( ),true,false) in rules

[telula]

Hello,
Will IF(OR(condition1,condition2),true,false) or IF(OR(condition1,condition2),true,false) work in rules?

[Alan Kirk]

Hello,
Will IF(OR(condition1,condition2),true,false) or IF(OR(condition1,condition2),true,false) work in rules?

Sure. If the "rules" are for Excel.

In TM1, however, the syntax is different. Refer to the Rules Guide, specifically the heading "Components of a Rule "

Using Logical Operators

You can combine expressions in a calculation statement using logical operators.

Operator: & (ampersand)
Meaning: AND
Example: (Value1 > 5) & (Value1 < 10)
Returns TRUE if the value is greater than 5 and less than 10.

Operator: % (percentage sign)
Meaning: OR
Example: (Value1 > 10) % (Value1 < 5)
Returns TRUE if the value is greater than 10 or less than 5.

Operator: ~ (tilde)
Meaning: NOT
Example: ~(Value1 > 5)
Equivalent to (Value1 <= 5)