Need Help with Soccer Table (please)

[hakiertan]

Hi Guys,

I'm tryiong to put together a soccer table together for me and my mates.
I have figured how to get the results for Goals Against vs Goals For & Goal Difference

But I cant seem to work out of the rest, what I am trying to do enable on the spreadsheet is.

When someone plays a game it will automatically upload in the games played field, and depending on the result they will get a W , D or L which will equals 3 for win , 1 for draw and 0 for loss

Pretty much a basic soccer table, but it's so hard to put together.

Any help will be highly appreciated.