RYG formula for indicating expense vs. budget

Amy Martin

Hi,

I am trying to use RYG balls to indicate how much remains in a budget (red indicates 90% spent, Yellow indicates 75% spent) Using this formula, I get green and yellow, but I can't seem to get red, even though there are expense/budget over 90%

=IF(Charged14 / [Budget Allocated]14 > 0.75, "Yellow", IF(Charged14 / [Budget Allocated]14 < 0.75, "Green", IF(Charged14 / [Budget Allocated]14 > 0.9, "Red")))

Any tips? Is there a better way of doing this?

Thank you!

Paul Newcome

Try putting your red as the first argument. Nested IF's work from left to right and stop at the first true value. Since 91% is greater than 75%, it flags the yellow argument as true and stops.

Paul Newcome

Try putting your red as the first argument. Nested IF's work from left to right and stop at the first true value. Since 91% is greater than 75%, it flags the yellow argument as true and stops.

Amy Martin

Paul to my rescue, again! That worked, thank you!

Paul Newcome

Happy to help. 👍️