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
Bookmarks