How do you calculate the following stats using XL.

What if I have a tie how does that change my calculations

Thank you in advance for your help.Carlos

Softball Standings

Team Wins Loss Tie % Games .Behind1. The Shock

2. Heart-Breakers

3. Terminators

4. Mustangs

5. All-Stars

Well, first off, softball games don't usually end in a tie. Even in recreational leagues where there is a time limit there can be rules to ensure that no game will end in a tie, e.g.

1 - No inning may start after 7 PM

2 - If the game is tied when Rule 1 is in effect, the score will revert to the score at the end of the latest inning when one team was in the lead.

3 - If no inning ended with one team in the lead, the Home team will be awarded a Win.If you must deal with ties, then one method is to give each team a half a win and half a loss.

These formulas gave me the same values as my newspaper shows for the AL East standings as of July 3, 2011.

Based on the lay out in the table below, enter this in D2 and drag it down:

=B2/SUM(B2:C2)

Enter this in E2 and drag it down:

=((MAX(B:B)-B2)+(C2-MIN(C:C)))/2

A B C D E 1 Team Win Lose % GB 2 New York 50 32 .610 - 3 Boston 49 34 .590 1.5 4 Tampa Bay 47 37 .560 4 5 Toronto 41 44 .482 10.5 6 Baltimore 36 45 .444 13.5

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thanks for your help.

Have a nice day.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History