Looking to populate a fourth cell based on the values in three other cells,
If A29 is blank and B29 is "green" and C29 is "red" the I would like cell D29 to be "Team B" otherwise I would like cell D29 to be "Team C".
I am unsure how to write this formula.