if statement for overall status

[legend905]

I have several variables (12) that all return either "GREEN", "GREY", "YELLOW", or "RED". I need a formula to return the following:

If all are either "GREY" or "GREEN" then "GREEN"
If any are "RED" then "RED"
IF none are "RED" and any are "YELLOW" then "YELLOW"

Can anyone help? Thanks

[GC Excel]

Hello,

Assuming your variables are "text" in A1:A12, try this formula:

Please Login or Register  to view this content.

[Phuocam]

Or try this ...

=LOOKUP(2,1/COUNTIF($A$1:$A$12,{"GREY","GREEN","YELLOW","RED"}),{"GREEN","GREEN","YELLOW","RED"})