Simple Function question?
 

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(S10S12,R10,R12)+IF(S10=S12,0))

Simple Function question?
 

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jboss73" wrote in message
...
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(S10S12,R10,R12)+IF(S10=S12,0))

Simple Function question?
 

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

"Bob Phillips" wrote:

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jboss73" wrote in message
...
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(S10S12,R10,R12)+IF(S10=S12,0))

Simple Function question?
 

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"jboss73" wrote in message
...
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(S10S12,R10,R12)+IF(S10=S12,0))