Football Scores

[Number_8]

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]

Try

=IF(AND(A1=C1,B1=D1),3,IF(AND(A1<B1,C1<D1),1,IF(AND(A1>B1,C1>D1),1,IF(AND(A1=B1,C1=D1),1,0))))

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]

Perfect thanks

[Bob Phillips]

I think this is it Simon

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

--

HTH

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


"Number_8" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:%[email protected]...
> I think this is it Simon
>
>
=IF(AND(A2=C2,B2=D2),3,IF(AND(A2=B2,C2=D2),1,IF(SIGN(A2-B2)=SIGN(C2-D2),1,0)
> ))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Number_8" <[email protected]> wrote
in
> message news:[email protected]...
> >
> > 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
> >
>
>