Cell Text not Cell number

[Brown]

Good Morning,
I am trying to throw together a master score sheet to calculate wins, loses, total runs scored, etc..
In the screen shot you can see F3 is returning the cell number not the team name. What have I done wrong here, and how can I fix it?

I know it should not be "b3" but I cannot think what should go there, and if b3 loses how can I tell it to identify d3?

Thanks
Brown

 

[Sam_D_Ben]

May be this,

=IF(C3>E3, B3, D3)

 

[Brown]

May be this,

=IF(C3>E3, B3, D3)

Thank you I will give that a try right now.
It worked like a charm! Thank you for that and have a great day.

 

[Fluff]

What should happen if it's a draw?

 

[Brown]

What should happen if it's a draw?

The games will be played out until there is a winner, extra innings. But, do you have a suggestion just in case we decide the game must be stopped at some point?

 

[Brown]

If this need to be another thread I will gladly move it.
Why is my formula not calculating wins for Allatoona and Fannin but working for the others?

 

[Fluff]

Check that there are no leading/trailing spaces.

 

[Brown]

Check that there are no leading/trailing spaces.

Check that there are no leading/trailing spaces.

When I checked for that I did not find any. The same formula is working fine for the other teams just not those two. Thanks for the help!

 

[Fluff]

Glad we could help & thanks for the feedback.