How to write a RYG formula for a range of values?
I am working on a formula for:
1) If cell is empty = Yellow
2) If cell is between 20 to 20 = Green
3) Otherwise = Red
How should I write this formula?
I am able to get the formula right if it is simpler as follows:
1) If cell is empty = Yellow
2) If cell is 0 = Green
3) Otherwise = Red
=IF(ISBLANK([Cell]@row), "Yellow", (IF([Cell]@row = 0, "Green", "Red")))
Appreciate assistance. Thank you.
Best Answer

Hi @Vivien Chong
Hope you are fine, please try the following formula and convert it to column formula:
=IF(ISBLANK(Amount@row), "Yellow", IF(AND(Amount@row <= 20, Amount@row >= 20), "Green", "Red"))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers

Hi @Vivien Chong
Hope you are fine, please try the following formula and convert it to column formula:
=IF(ISBLANK(Amount@row), "Yellow", IF(AND(Amount@row <= 20, Amount@row >= 20), "Green", "Red"))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 465 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!