# Formula to award points for goal difference

1. ## Formula to award points for goal difference

Hello.

The following sheet shows 4 weeks of Championship football results. I want the following points to appear in column B.
Taking Barnsley as an example, in week 1 they achieved 1 point; in week 2, 5 points; in week 3, 1 point and in week 4, 3 points. Total 10 points

Watford's points are, week 1, 1 point; week 2, 3 points; week 3, -2 points; and in week 4, 2 points. Total 4 points.

So, I want column B to show all points won for the previous 4 matches played, and columns O and P to show the relevant points won depending on the fixtures.

Home win with 1 goal difference: 1 point
Home win with 2 goals difference: 3 points
Home win with 3 and more than 3 goals difference: 6 points
Away win with 1 goal difference: 2 points
Away win with 2 goals difference: 5 points
Away win with 3 and more than 3 goals difference: 7 points
Home draw: 0 points
Away draw: 1 point
Home defeat: -4 points (negative)
Away defeat: -2 points (negative)

Thank you.

2. ## Re:Formula to award points for goal difference

I'm wondering if it would be easier if the football results were in their own columns, so I've now added another sheet. Hope this helps and that the instructions are clear.
Thank you.

3. ## Re: Formula to award points for goal difference

Sorry, I made a mistake with some of the cell references. I've also add some fixtures to the sheet.

4. ## Re: Formula to award points for goal difference

I'm trying desperately to find the correct formula that solves my problem. The formula in D2 works but I can't find a way to expand the IF statement so that it
solves the other goal difference possibilities as shown in the previous post. I've tried using IFAND but I can't get the right number of arguments.

Thank you for any help.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1