RYGB BAlls with B = empty cell
I have a basic formula I can't get to return a B ball when there is an empty cell.
=IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))
Best Answers
-
Move that argument to the beginning.
=IF(Count@row = "", "Blue", IF(Count@row = 0, "Green", IF(Count@row > 0, "Red")))
-
Try this one instead...
=IF(Count@row = 1, "Green", IF(Count@row = 0, "Blue", "Red"))
Answers
-
Move that argument to the beginning.
=IF(Count@row = "", "Blue", IF(Count@row = 0, "Green", IF(Count@row > 0, "Red")))
-
Thank you Paul. That did the trick. I'm new at this and am learning :). I have another quick question:
=IF(Count@row = 0, "Blue", IF(AND(Count@row >.01, count@row <1, "Red", IF(Count@row = 1, "Green"))))
0=Blue
Between .01-.99 =Red
1=Green
-
Try this one instead...
=IF(Count@row = 1, "Green", IF(Count@row = 0, "Blue", "Red"))
-
You're great! Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!