If-and-isblank

[osaben]

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.

 

[JoeMo]

=IF(AND(A29="",B29="green",C29="red"),"Team B","Team C")

 

[osaben]

thank you. But this formula does not seem to work. it continues to bring back "Team C" regardless if A29 is blank.

 

[osaben]

cell a29 is blank, but it is a formula. Maybe that matters?

 

[Trebor76]

cell a29 is blank, but it is a formula. Maybe that matters?

No, that won't matter. Are you sure there's no spaces in any of the cells? To confirm use the LEN function for each cell in the range A29:C29 i.e. LEN(A29), LEN(B29) and LEN(C29) and confirm the formulas return 0, 5 and 3 respectively.

Robert

 

[Michael M]

What is the formula in A29 ??

 

[osaben]

What is the formula in A29 ??

it was hidden spaces. the formula now works! Thanks to all!

 

[Trebor76]

You're welcome. It's not that they're hidden but not visible.