sports score sheet

[Guest]

i want to assign points (3 for win, 1for draw) to a table of results i hve
created. i have worked out the total goals scored and the goal difference but
can not work out how to assign the winning team points.
eg A1 is 3 A4 is 1. A1 won 3-1 , i can put the goals into a table of
results but can not work out how to assign points
any help appreciated!!

 

[Andy B]

Hi
Use an IF formula. In the A1 team's points cell use something like:
=IF(A1>A4,3,IF(A1<A4,0,1))
In the A4 team's points cell use:
=IF(A4>A1,3,IF(A4<A1,0,1))
Hope this helps.

Andy.