Quote Originally Posted by Bau View Post
That formula works fine as long as there are no tie games involved. How do I modify the formula to account for ties?
Tie games are commonly considered half a win and half a loss. Assuming you are considering them the same, the following should work.

=(((max($B$2:$B$100)+(D2/2))-B2)+((D2/2)+C2-min($C$2:$C$100)))/2

This is assuming "wins" are in column B, "losses" in column C and "ties" in column D. The ranges for max and min would start at the uppermost cell that contains a win or loss and end with the bottom most cell that contains a value involving the items you're comparing.

For example, if you have different divisions of four teams each and the wins and losses for the first division are located in cells B2:C5, your max and min ranges would be $B$2:$B$5 and $C$2:$C$5, respectively.

Also note that teams that have completed a different number of games can skew the games behind computation and winning percentage is a better indicator of placement.

Hope this helps!