IF Function Question

[mogabi]

Hello! I hope someone can help me. I am trying to set up a tournament bracket.

I have this function in cell D16:

=if(G7=D5,D9,if(G7=D9,D5,""))

Until data is entered into cell G7, I do not want this function to return any value. I want this cell (D16) to be blank.

The trouble I am having is that if D5 says "team1" but D7 and G7 are both empty at the moment, D16 will return the value "team1." I understand why this is happening, but I don't want it to happen. I want D16 blank until data is entered into G7.

Hopefully someone can help and hopefully this makes sense.

Thanks in advance!

[JBeaucaire]

Try this:

=IF(G7="", "", IF(G7=D5, D9, IF(G7=D9, D5, "")))

[mogabi]

JBeaucaire, you are a saint. Thank you so much.