RYGB BAlls with B = empty cell

Alishia Topper

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")))

Paul Newcome

Move that argument to the beginning.

=IF(Count@row = "", "Blue", IF(Count@row = 0, "Green", IF(Count@row > 0, "Red")))

Paul Newcome

Try this one instead...

=IF(Count@row = 1, "Green", IF(Count@row = 0, "Blue", "Red"))

Paul Newcome

Move that argument to the beginning.

=IF(Count@row = "", "Blue", IF(Count@row = 0, "Green", IF(Count@row > 0, "Red")))

Alishia Topper

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

Paul Newcome

Try this one instead...

=IF(Count@row = 1, "Green", IF(Count@row = 0, "Blue", "Red"))

Alishia Topper

You're great! Thank you. 

Paul Newcome

Happy to help! 👍️