Simple Function question?

J

jboss73

This is a simple mistake but for some reason I can not get around it...any
help would be great.

What I am trying to accomplish is to have one cell (in this case T11)
display the winner of a game from cells R10 and R12. I am using "IF" >, <
and = to display the winner or a tie. The problem I am running into is if
they two cells have not played yet, it will show in cell T11 the first cell
(R10) as the winner. Is there a formula to add to this so it will not show a
winner in T11 until a number is in place? Here is my formula:
=(IF(S10>S12,R10,R12)+IF(S10=S12,0))
 
B

Bob Phillips

Don't, know where S10 and S12 come into it

=IF(OR(R10="",R12=""),"",IF(R10>R12,R10,IF(R10<R12,R12,"tie")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

jboss73

Got it.....thanks for your help!

Bob Phillips said:
Don't, know where S10 and S12 come into it

=IF(OR(R10="",R12=""),"",IF(R10>R12,R10,IF(R10<R12,R12,"tie")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
A

Arvi Laanemets

Hi

When R10:R11 contain player names, and S10:S11 their scores, then
=CHOOSE(IF(OR(S10="";S11="");1;(S10>S11)+2*(S10>S11)+1);"Tie";R10;R11)
 
Top