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