Football scores on Excel

[Graham]

Hi
I would like Excel to calculate football scores /points.
eg

TeamA 2 goals
TeamB 1 goals
and show results in another column as
TeamA 3 points
TeamB 0 points

or

TeamC 2 goals
TeamD 2 goals
and show results in another column as
TeamA 1 point
TeamB 1 point

If a team win they get 3points
If a team draws they get 1 point
If a team loses they get no points

Thanks for your help
Graham

 

[jr]

use:
=IF(C21>D21,3,IF(C21=D21,1,0))
=IF(C21<D21,3,IF(C21=D21,1,0))
to test two columns of team scores ... C21 containing
first team and D21 containing second team

 

[jr]

sure, I'd love to see it.

-----Original Message-----
JR
Thank you

Thats got it.
It will take me a while to put the score sheet together.
May I send you a copy when completed?

Thanks again
Graham
.