Please could I have a suggestion for a formula for the below
If budget forecast is between 90-100% green, if budget forecast is greater than 100% but less than 103% OR between 80-90% yellow otherwise red
Best Answer
-
My apologies. Wrong function.
=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(AND([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))
Answers
-
Try something like this:
=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(OR([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))
-
Hi Paul
Thanks, the first bit works (i.e. 90-100% goes green, anything else goes yellow, I don't get a red symbol regardless of the number
-
My apologies. Wrong function.
=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), "Green", IF(AND([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), "Yellow", "Red"))
-
works perfectly, thanks!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!