AND and OR logical operators

scwooten

In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example:

IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE. 

In this context, these operators are defined as:

• AND - a statement that evaluates two or more Booleans and returns TRUE when all statements are true
• OR - a statement that evaluates two or more Booleans and returns TRUE when any statement is true

rob_marshall

@scwooten 

 

Why can't you use this formula:   A=1 AND B=2 with the format being a Boolean.

scwooten

@rob_marshall Yes, that works but on some of models the requirement to add multiple such Booleans greatly expands total cell count. 

rob_marshall

@scwooten 

 

Honest question, how is having a formula of A=1 AND B=2 any different than AND(A=1,B=2)?