# Formula to compute win/loss percentage

How do I compute win/loss percentage for the games we've played
?

 AdamUTsel Posts: 100, Reputation: 5 Junior Member #2 Sep 25, 2008, 02:44 PM

Total games won / Total games played = Winning percentage

Total games lost / Total games played = Losing percentage

Winning percentage + Losing percentage = 1.00

**Assuming no ties**
 DolFanMan Posts: 1, Reputation: 10 Junior Member #3 Dec 8, 2009, 11:21 AM
For ties add a half, for example,

Record is 8-4-1

8 Wins + .5 for 1 Tie = 8.5 / 13 total games = .654
 dipincochin Posts: 1, Reputation: 10 Junior Member #4 Feb 14, 2012, 03:50 AM
Loss Percentage = (Loss Percentage / Selling Price)*100
 ictcowboy Posts: 2, Reputation: 1 New Member #5 Dec 30, 2012, 11:04 AM
I prefer to use the following formula, especially in Excel:

(Wins/Wins+Losses+Ties)+1-(Losses/Wins+Losses+Ties))/2

This gives you an accurate winning percentage regardless if there are ties involved or not.
 ictcowboy Posts: 2, Reputation: 1 New Member #6 Dec 30, 2012, 11:06 AM
Quote:
 Originally Posted by ictcowboy I prefer to use the following formula, especially in Excel: (Wins/Wins+Losses+Ties)+1-(Losses/Wins+Losses+Ties))/2 This gives you an accurate winning percentage regardless if there are ties involved or not.
I forgot to add a few Parenthesis; it should be:

(Wins/(Wins+Losses+Ties)+1-(Losses/(Wins+Losses+Ties)))/2

## Check out some similar questions!

Percentage formula [ 2 Answers ]

I'm trying to find out what number is 39,200, 2 percent of Is there a formula

I've been working out for the past week, and I've been feeling a bit slimmer, but when I weighed myself the other day I hadn't lost any weight, but my body fat percentage went down about 10%. Is this possible, or did the scale screw up?

Excel Percentage Formula [ 3 Answers ]

Using an Excel worksheet, what is the formula for the percentage of wins for a team. Example 2 wins and 1 loss equals what percentage of wins?

How do I compute expenses? [ 2 Answers ]

Compute the missing amount for company. You will need to prepare a statement of owners's equity. Did company earn a net income or suffer a net loss for the year? Compute the amount. Beginning: Assets 50,000 Liabilities 20,000 Ending: Assets 70,000 Liabilities 35,000