AND and OR logical operators
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
Why can't you use this formula: A=1 AND B=2 with the format being a Boolean.0
@rob_marshall Yes, that works but on some of models the requirement to add multiple such Booleans greatly expands total cell count.0
Honest question, how is having a formula of A=1 AND B=2 any different than AND(A=1,B=2)?0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!