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

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)

"jboss73" <jboss73@discussions.microsoft.com> wrote in message
news:D203FC4A-2F10-4971-BE80-47055D90FB94@microsoft.com...
> 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))

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

"Bob Phillips" wrote:

> 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)
>
> "jboss73" <jboss73@discussions.microsoft.com> wrote in message
> news:D203FC4A-2F10-4971-BE80-47055D90FB94@microsoft.com...
> > 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))
>
>
>

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)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"jboss73" <jboss73@discussions.microsoft.com> wrote in message
news:D203FC4A-2F10-4971-BE80-47055D90FB94@microsoft.com...
> 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))