RYG formula for indicating expense vs. budget

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!

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.