I have two numbers or dates
Baseline budget 100,000
Current budget 35,000
Variance is 65,000
If I do a % calculation (variance/baseline) then its 65%
I have a health indicator that says if the variance is > 10% then red, more than 5% and < 9% then yellow, lower then green.
However, we are WAY under budget in this example so it goes red - how do I fix?
sorry I'm being dense
Help Article Resources
Check out the Formula Handbook template!