+ Reply to Thread
Results 1 to 4 of 4

Formula to award points for goal difference

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2016
    Posts
    208

    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.

    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by tom hatten; 03-19-2021 at 12:00 PM.

  2. #2
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2016
    Posts
    208

    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.

    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by tom hatten; 03-19-2021 at 12:00 PM.

  3. #3
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2016
    Posts
    208

    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.

    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by tom hatten; 03-19-2021 at 12:00 PM.

  4. #4
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2016
    Posts
    208

    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.

    https://docs.google.com/spreadsheets...it?usp=sharing

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to correctly award points for football scores
    By ozarks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-01-2020, 12:24 AM
  2. Help with football points spread sheet formula please
    By domj1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2017, 11:56 AM
  3. need a formula that searches football results but only last 6
    By jono121ukk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2016, 03:24 PM
  4. Football result formula for awarding points
    By Hine85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2013, 02:50 PM
  5. Replies: 3
    Last Post: 09-18-2012, 09:50 AM
  6. Formula required to calculate points for football results prediction
    By Jen1979 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-15-2009, 11:46 AM
  7. Formula to award points for football score prediction
    By OliverW in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-30-2008, 08:52 AM

Bookmarks

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