IF Formula
Hello,
Not sure how to create column formula for the following criteria utilizing RYGB color formatting:
• 0-29% red
• 30-49% yellow
• 50-99% green
• 100% blue
Best Answer
-
The IF() formula can be written to flow exactly as you described/outlined it.
If it's less than or equal to 29%, then Red; if it's less than or equal to 49%, then Yellow; if it's less than or equal to 99%, then Green; else, Blue.
Let's say that the percent complete is in a column labeled "Progress". Your formula would be...
IF( Progress@row <= 0.29 , "Red", IF( Progress@row <= 0.49 , "Yellow", IF(Progress@row <= 0.99, "Green", "Blue" ) ) )
Answers
-
The IF() formula can be written to flow exactly as you described/outlined it.
If it's less than or equal to 29%, then Red; if it's less than or equal to 49%, then Yellow; if it's less than or equal to 99%, then Green; else, Blue.
Let's say that the percent complete is in a column labeled "Progress". Your formula would be...
IF( Progress@row <= 0.29 , "Red", IF( Progress@row <= 0.49 , "Yellow", IF(Progress@row <= 0.99, "Green", "Blue" ) ) )
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!