I have 3 conditional formatting ranges • 0-39 RED•40-89 Yellow• >90 GreenI 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
Go to Solution.
@PranayG Could you please share screenshot of conditional formatting setting?
You can set a midpoint in it and enter 0.5 as the midpoint value.
View solution in original post
Hi @KirillKuznetsov , Thank you for the quick revert. I was not using the decimal values and using the whole number. Silly mistake. 😛
Rather than using long IF THEN ELSE statements, give this article a try written by @JaredDolich
Thanks @rob_marshall for the shout out.
@PranayG Going back to DISCO, this would be the transformation module or the "C". Prevents the need for a lot of IF THEN.