Free calculator
Winning percentage calculator (wins, losses, ties)
Enter a W–L–T record to get winning % the way standings tables usually do: each tie counts as half a win in the numerator ((W + 0.5×T) ÷ (W+L+T)). This is not live in-game win probability (a different model) and not betting implied odds—just clear math you can mirror in Google Sheets or Excel.
When to use this calculator
You already have counts and want a single headline %—same pattern for sports, leagues, or pipeline snapshots.
- Sports & esports: quick check of a team’s record % including ties where your rulebook uses the ½-win convention.
- Sales or CX: treat closed-won as W, closed-lost as L, and use T only if you truly model partial outcomes—otherwise set T to 0.
- Sheets sanity check: compare this page to a one-line IF formula in your workbook before you paste into a standings model.
- Need generic % math? Open the percentage calculator linked in the methodology section.
Start from three non-negative integers: wins, losses, and ties. Add them to get games played. Add half a win for each tie to get win value, then divide by games and scale to a percent.
Count games played
Games = W + L + T. If this sum is 0, there is no rate to report—enter at least one result row first.
Credit ties as half wins
Win value = W + 0.5 × T. This matches the usual standings treatment where a tie is worth half of a win and half of a loss compared with a decisive game.
Convert to a percentage
Winning % = (win value ÷ games) × 100. The result is between 0 and 100 for ordinary records; we round for display but keep the same formula in your sheet.
We do not model remaining schedule projections, magic numbers, Elo, or in-game win probability—those need different inputs and engines.
For generic percentage change and of calculations, use the percentage calculator. For gain vs invested on a single round trip, see the ROI calculator.
FAQs cover sales win rate, win–loss ratio wording, rounding, and why this page is not an odds converter.
Google Sheets & Excel
Put wins, losses, and ties in three cells (say A2, B2, C2). The standard standing style winning percentage is =(A2+0.5*C2)/(A2+B2+C2) when the denominator is not zero—wrap with IF(A2+B2+C2=0,"",…) to avoid divide-by-zero. Replace A2/B2/C2 with your references; use Formulas → Insert function to match your language pack’s function names.
=(A2+0.5*C2)/(A2+B2+C2)W in A2, L in B2, T in C2. Format the cell as percent or multiply by 100 for a 0–100 display to match this page.
=IF(A2+B2+C2=0,"",(A2+0.5*C2)/(A2+B2+C2))Returns blank when W+L+T is 0 so you do not divide by zero.
More tools in Spreadsheet math
Browse all toolsSlide 1 of 17
Frequently asked questions
What is winning percentage?
Winning percentage here means (wins + ½×ties) ÷ (wins + losses + ties), expressed as a percent. It answers “what fraction of games did the team bank as wins, counting ties as half?”—not “what are the odds they win the next game?”
How do ties affect winning percentage?
Each tie adds ½ to the win value numerator while still counting as one game in the denominator. All ties and no wins or losses yields 50%.
Is winning percentage the same as win–loss ratio?
No. Win–loss ratio is usually quoted as W : L (or W ÷ L) and ignores ties differently depending on the writer. Winning percentage folds ties into a single 0–100% number using the ½-win convention above.
Can I use this for sales “win rate”?
Often yes if you define W as won opportunities, L as lost, and T as true ties/partial stages you want to count as half wins. If you only have won vs total with no ties, set T = 0 and verify W + L matches your total opportunities definition.
Is this a live win probability calculator?
No. In-game models use score, time, possession, and similar inputs. This page only needs final W–L–T counts for a season-to-date style percentage.
Can I convert betting odds here?
No. Converting decimal or American odds to implied probability is a different workflow (and usually needs margin / vig awareness). This tool stays on the record-based definition above.
Why do I see an error when all counts are zero?
With W = L = T = 0, there are no games yet, so the percentage is undefined (division by zero). Enter your played results first.
How should I format this in Google Sheets or Excel?
Use =(W+0.5*T)/(W+L+T) with cell references, or the IF guard shown in the Google Sheets & Excel section so blank preseason rows do not error.
How do you round?
We show up to two decimal places for the headline % using normal display rounding. Your sheet may differ if cells carry extra precision—compare formulas, not only formatted cells.
What if my Excel is in German?
The math is the same; IF is often WENN in German installs. Use Formeln → Funktion einfügen to match labels for your language pack.
What if my Excel is in French?
Same numbers; IF is often SI. Use Formules → Insérer une fonction to confirm names on your build.
Is this suitable for contract or compliance decisions?
No. It is a transparent teaching and spreadsheet companion. When official standings, seeding, or regulatory rules apply, follow the governing body or your counsel—not this page alone.