IF & AND statements

[hip]

I can't quite get it right.

Let me lay it out:

A1--------A2-----A3------A4
Team 1--score--score--team 2
B1--------B2-----B3-------B4
Team 1--score--score--team 2
-------------------------------------c6
-----------------------------------winner

The idea is that you enter the score between 2 teams in A2 & A3 wit
the winner being placed in C6. Easy enough.

However this is for soccer and it could go into penalties. That's wh
we have Row B in there.

I can't come up with a formula that will say something to the effec
of:

if team 1 wins they go into c6, if team 2 wins they go into c 6, i
it's a tie then refer to row B and do the same thing. :eek

 

[Guest]

Try:

=IF(B1=C1,IF(C2>B2,D2,A2),IF(B1>C1,A1,D1))

Ian

 

[Bob Phillips]

=IF(A2+B2>A3+A3,A1,A4)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Much more elegant Bob! (even with the typo!!)

=IF(A2+B2>A3+A3,A1,A4)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

I laid it out incorrectly at forts, by columns not rows, and only just
spotted it as I was posting. That's my excuse anyway <G>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[hip]

It worked, thanks Bob and Ian