Formula help

Steve DeLuca

I have a formula set to change to RYGB balls depending on children. The formula is as follows:

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green")))

This formula works great.

I now want to add another statement to this that will change the ball to BLUE, i.e; 

When all children are complete (Blue), change to "Blue".

I can't seem to figure this out. What is the operator for "ALL"?

 

L_123

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") =count(children()),"Blue","Green"

 

give that a try and see what it gives you.

Steve DeLuca

Works perfectly! Thank You