View Full Version : Formula to compute win/loss percentage
ofbarber
Sep 25, 2008, 01:28 PM
How do I compute win/loss percentage for the games we've played
?
AdamUTsel
Sep 25, 2008, 01: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
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
Feb 14, 2012, 03:50 AM
Loss Percentage = (Loss Percentage / Selling Price)*100
ictcowboy
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
Dec 30, 2012, 11:06 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.
I forgot to add a few Parenthesis; it should be:
(Wins/(Wins+Losses+Ties)+1-(Losses/(Wins+Losses+Ties)))/2