Hi,

I have an xls with a list of football matches. In column A I will have
the home scores and in column B, I will have teh away team's scores. I
then have in column C my predicition for teh home team and in column D
the away team score predcition. I want column E to compare teh two sets
of scores and award me 3 points for an exact match of the scores and 1
point if I predict teh correct wwinner or a draw. - How can I do this?

Thanks

Simon


--
Number_8
------------------------------------------------------------------------
Number_8's Profile: http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=395265

Try


=IF(AND(A1=C1,B1=D1),3,IF(AND(A1<B1,C1<D1),1,IF(AN D(A1B1,C1D1),1,IF(AND(A1=B1,C1=D1),1,0))))





Number_8 Wrote:
Hi,

I have an xls with a list of football matches. In column A I will have
the home scores and in column B, I will have teh away team's scores. I
then have in column C my predicition for teh home team and in column D
the away team score predcition. I want column E to compare teh two sets
of scores and award me 3 points for an exact match of the scores and 1
point if I predict teh correct wwinner or a draw. - How can I do this?

Thanks

Simon


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395265

Perfect thanks


--
Number_8
------------------------------------------------------------------------
Number_8's Profile: http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=395265

I think this is it Simon

=IF(AND(A2=C2,B2=D2),3,IF(AND(A2=B2,C2=D2),1,IF(SI GN(A2-B2)=SIGN(C2-D2),1,0)
))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Number_8" wrote in
message ...

Hi,

I have an xls with a list of football matches. In column A I will have
the home scores and in column B, I will have teh away team's scores. I
then have in column C my predicition for teh home team and in column D
the away team score predcition. I want column E to compare teh two sets
of scores and award me 3 points for an exact match of the scores and 1
point if I predict teh correct wwinner or a draw. - How can I do this?

Thanks

Simon


--
Number_8
------------------------------------------------------------------------
Number_8's Profile:
http://www.excelforum.com/member.php...fo&userid=6590
View this thread: http://www.excelforum.com/showthread...hreadid=395265

Mine can be simplified a bit

=IF(AND(A2=C2,B2=D2),3,IF(AND(A2=B2,C2=D2),1,--(SIGN(A2-B2)=SIGN(C2-D2))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
I think this is it Simon


=IF(AND(A2=C2,B2=D2),3,IF(AND(A2=B2,C2=D2),1,IF(SI GN(A2-B2)=SIGN(C2-D2),1,0)
))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Number_8" wrote
in
message ...

Hi,

I have an xls with a list of football matches. In column A I will have
the home scores and in column B, I will have teh away team's scores. I
then have in column C my predicition for teh home team and in column D
the away team score predcition. I want column E to compare teh two sets
of scores and award me 3 points for an exact match of the scores and 1
point if I predict teh correct wwinner or a draw. - How can I do this?

Thanks

Simon


--
Number_8
------------------------------------------------------------------------
Number_8's Profile:
http://www.excelforum.com/member.php...fo&userid=6590
View this thread:
http://www.excelforum.com/showthread...hreadid=395265