How to apply IF AND function in ANAPLAN
I have 3 conditional formatting ranges
• 0-39 RED
• >90 Green
I am able to return correct values for RED and Green , but what formula do I use to tell the model Yellow is between 40 and 89?
I at the moment used this formula -
IF Attainment <= 0.39 THEN 0 ELSE IF Attainment >= 40 AND Attainment <= 89 THEN 0.5 ELSE 1