+ Reply to Thread
Results 1 to 4 of 4

Baseball Standing using IF function

  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    ATLANTA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Baseball Standing using IF function

    I have created a spreadsheet to keep track of my leagues little league standings. When I calculate the Games Behind "GB" column, I use a IF function. Because some teams have TIES, it has thrown a wrench in the function. I need the function to also account for loses. I tried a nested AND, but could not get the function to return the "DIV LEADER" results. Here is the function.

    =IF(MAX($G$2:$G$10)=G2,"Div Leader",((MAX($D$2:$D$10)-D2)+(E2-MIN($E$2:$E$10)))/2)

    Attached is the spreadsheet. Any help would be appreciated, its killing me. Thanks,
    Just in case the sheet did not attach here is an excerpt. You see two teams with 5 wins and both listed a Div Leader, however, the team with the one lose actually should be the Div Leader and the other team should be 0 games behind. Thanks


    A B C D E F G H I J K L
    Games Played GB Team W L T Win % Allowed Scored Diff Allow/G Score/G
    7 Div Leader Auburn 5 1 1 71% 68 114 46 9.71 16.29
    7 Div Leader GA Tech 5 2 0 71% 81 92 11 11.57 13.14
    7 2 Texas A&M 3 3 1 43% 99 86 -13 14.14 12.29
    7 2.5 Kentucky 3 4 0 43% 92 94 2 13.14 13.43
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Baseball Standing using IF function

    How about this...

    =IF(AND(MAX($G$2:$G$10)=$G2,MIN($E$2:$E$10)=$E2),"Div Leader",((MAX($D$2:$D$10)-$D2)+($E2-MIN($E$2:$E$10)))/2)

    Windy

  3. #3
    Registered User
    Join Date
    10-14-2013
    Location
    ATLANTA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Baseball Standing using IF function

    Thanks, that was it. I had the same fix, but my ( ) were in the wrong place. Its the little things. Thanks,

  4. #4
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Baseball Standing using IF function

    Glad to be of help.

+ 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. Replies: 10
    Last Post: 04-15-2013, 12:45 PM
  2. standing ranking auto sort
    By iamreese in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2012, 11:48 PM
  3. Creating a macro to add and subtract from a standing count
    By kung in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-06-2009, 05:02 PM
  4. automatically calculates the standing
    By CLWLK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2006, 01:10 AM
  5. [SOLVED] Free-standing macros
    By Pflugs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2005, 05:05 AM

Tags for this Thread

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