+ Reply to Thread
Results 1 to 3 of 3

Games Back Formula

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    8

    Games Back Formula

    Hello All,
    I am trying to make something that auto calculates the standings from game results. From what I have found online I have been able to do. The problem is I can't figure out how to do a formula for getting the games back (GB). What I have been able to find is a formula for just wins and loses but that doesn't necessarily work here because I have ties as well. Below is the table and I have manually entered what the games back should be. As you can see, the teams aren't going to be in order.

    Team GP W L T % GB
    Team 1 9 8 0 1 0.944 0
    Team 2 9 4 5 0 0.444 4.5
    Team 3 9 6 2 1 0.722 2
    Team 4 9 5 4 0 0.555 3.5
    Team 5 9 5 3 1 0.611 2.5
    Team 6 9 8 0 1 0.944 0
    Team 7 9 8 1 0 0.888 0.5

    I have found formulas using MAX but I am not sure how to use that.

    The formula for games back is GB == ((difference in wins) + (difference in losses)) / 2
    Ties are supposed to count as 1/2 win, 1/2 loss.

    Thank you in advance, I appreciate your time. (sorry the chart is sloppy, I attached the sheet in case it's easier for you)
    Attached Files Attached Files
    Last edited by socal.s; 02-18-2015 at 07:50 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Games Back Formula

    Hey socal.s

    GB might mean Games Back or Games behind the leader?? See my attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-08-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Games Back Formula

    Thanks MarvinP, I'm going to say that's exactly what I needed.... I was drawing blanks!

    PERFECT!

+ 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. Games Behind Formula
    By Milomet in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-24-2020, 03:24 PM
  2. Formula to calculate win/lost for last n games
    By cap_investing in forum Excel General
    Replies: 13
    Last Post: 01-06-2015, 07:50 PM
  3. Shortest Formula Challenge!! (Games 6 & 7)
    By clabulis in forum The Water Cooler
    Replies: 29
    Last Post: 07-30-2014, 10:11 AM
  4. Shortest Formula Challenge!! (Games 1-3)
    By clabulis in forum The Water Cooler
    Replies: 98
    Last Post: 07-11-2014, 06:12 PM
  5. Replies: 7
    Last Post: 08-03-2013, 09:51 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