How to Calculate Winning Percentage (With Ties, and Games Behind)
The formula, what to do with ties, how games behind works, and a calculator to check your own standings.
Winning percentage is the fraction of games a team has won, and it is the fairest single number for ranking teams that have not all played the same number of games. Here is the formula, what to do with ties, how to work out games behind, and a calculator for checking your own numbers.
The winning percentage formula
Winning percentage = Wins ÷ (Wins + Losses)
A team that is 9–3 has won 9 of 12 games: 9 ÷ 12 = 0.750. Standings write it with three decimals and no leading zero, so it shows as .750. An unbeaten team is 1.000 and a winless one is .000.
To turn it into an everyday percentage, multiply by 100: .750 is 75%. Both mean the same thing; sports just prefer the three-decimal form.
Winning percentage with ties
Ties are where leagues quietly disagree. There are two common conventions, and the one you pick changes the standings:
1. A tie counts as half a win and half a loss
This is the NFL’s rule and the most common choice in rec leagues:
(Wins + Ties ÷ 2) ÷ (Wins + Losses + Ties)
2. Ties are left out entirely
Only decisions count, so the formula stays Wins ÷ (Wins + Losses) and a tie changes nothing.
For a team at 8–3–1, the first rule gives 8.5 ÷ 12 = .708. The second gives 8 ÷ 11 = .727. Write down which one your league uses before the season, because a single tie can flip two teams in the table.
Leagues with overtime losses (hockey) usually skip winning percentage and rank on points instead. When teams have played different numbers of games, use points percentage: points ÷ (games played × 2). The NHL used it to settle the standings when the 2019–20 season was cut short.
Win percentage calculator
Win %
.750
Games behind
1.5
How to calculate games behind
Games behind (GB) says how far a team trails the leader, counting a win for one team and a loss for the other as one game:
GB = ((Leader’s wins − Team’s wins) + (Team’s losses − Leader’s losses)) ÷ 2
If the leader is 11–2 and a team is 9–3, the gap is (11 − 9) + (3 − 2) = 3, halved: 1.5 games behind. A half game appears whenever two teams have played a different number of games.
| Team | W | L | PCT | GB |
|---|---|---|---|---|
| Hammers | 11 | 2 | .846 | — |
| Comets | 9 | 3 | .750 | 1.5 |
| Rockets | 8 | 5 | .615 | 3 |
| Bears | 6 | 6 | .500 | 4.5 |
| Owls | 2 | 10 | .167 | 8.5 |
Wins, winning percentage or points?
Pick the ranking number to suit your schedule:
- Total wins is fine only when every team has played the same number of games. One rainout and it starts to lie.
- Winning percentage is the safe default for any league with byes, rainouts or an uneven schedule, which in practice is most of them.
- Points (say 2 for a win and 1 for a tie) suit sports with lots of ties or overtime results, like soccer and hockey. Switch to points percentage if the number of games played drifts apart.
Whatever you choose, you will still get teams level on it. That is what tiebreaker rules are for.
Doing it in a spreadsheet
With wins in column B, losses in C and ties in D, the spreadsheet formulas are =B2/(B2+C2) without ties and =(B2+D2/2)/(B2+C2+D2) with them. Wrap either in IFERROR(…, "") so a team that has not played yet does not show a divide-by-zero error, and format the cell to three decimal places.
Common questions
- What is the formula for winning percentage?
- Wins divided by games played (wins plus losses). A 9–3 team has a winning percentage of 9 ÷ 12 = .750.
- How do ties count in winning percentage?
- Most leagues count a tie as half a win and half a loss: (W + T ÷ 2) ÷ (W + L + T). Some leave ties out and use W ÷ (W + L). Say which in your league rules.
- How do you calculate games behind?
- Add the leader’s extra wins to the team’s extra losses and divide by two. A 9–3 team behind an 11–2 leader is ((11 − 9) + (3 − 2)) ÷ 2 = 1.5 games behind.
- Why does a winning percentage show as .750 instead of 75%?
- It is a sports convention: three decimal places with no leading zero. .750 and 75% are the same number.