How to apply IF AND function in ANAPLAN

[PranayG]

I have 3 conditional formatting ranges
• 0-39 RED
•40-89 Yellow
• >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

[KirillKuznetsov · Accepted solution]

@PranayGCould you please share screenshot of conditional formatting setting?

You can set a midpoint in it and enter 0.5 as the midpoint value.

[PranayG]

Hi@KirillKuznetsov, Thank you for the quick revert. I was not using the decimal values and using the whole number. Silly mistake.

[rob_marshall]

@PranayG

Rather than using long IF THEN ELSE statements, give this article a try written by@JaredDolich

https://community.anaplan.com/t5/How-To/Planning-Sales-or-Invoices-Using-Tier-Pricing/ta-p/60614

Rob

[JaredDolich]

Thanks@rob_marshallfor the shout out.

@PranayGGoing back to DISCO, this would be the transformation module or the "C". Prevents the need for a lot of IF THEN.