Help with Budget Health formula
I stink at formulas and am trying to calculate budget health. If my Budget is greater than my Actual, it's green. If my Budget is less than my Actual, it's red.
I'm using =IF([Budget]@Row > [Actual]@row, "Green", if [Budget]@Row < [Actual]@Row, "Red"))
How do I write this correctly?
Best Answer
-
Hello @Stephen Huff ,
Can you confirm for me if there is a "(" after the second IF statement? ( as shown below )
=IF([Budget]@Row > [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))
Also, what status would you want if the Budget = Actual? If you would want it to be green, the formula just need one symbol added ("=" next to ">"):
=IF([Budget]@Row >= [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))
Best,
Lidiya Shutaya
lidiya@ddbconsultants.ca
Answers
-
Hello @Stephen Huff ,
Can you confirm for me if there is a "(" after the second IF statement? ( as shown below )
=IF([Budget]@Row > [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))
Also, what status would you want if the Budget = Actual? If you would want it to be green, the formula just need one symbol added ("=" next to ">"):
=IF([Budget]@Row >= [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))
Best,
Lidiya Shutaya
lidiya@ddbconsultants.ca
-
Thank you! This works :-)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives