sports score sheet
 

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!!

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

Andy.

"rc" wrote in message
...
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!!