Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Formula to compute win/loss percentage (https://www.askmehelpdesk.com/showthread.php?t=263898)

  • Sep 25, 2008, 01:28 PM
    ofbarber
    Formula to compute win/loss percentage
    How do I compute win/loss percentage for the games we've played
    ?
  • Sep 25, 2008, 01:44 PM
    AdamUTsel

    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**
  • Dec 8, 2009, 11:21 AM
    DolFanMan
    For ties add a half, for example,

    Record is 8-4-1

    8 Wins + .5 for 1 Tie = 8.5 / 13 total games = .654
  • Feb 14, 2012, 03:50 AM
    dipincochin
    Loss Percentage = (Loss Percentage / Selling Price)*100
  • Dec 30, 2012, 11:04 AM
    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.
  • Dec 30, 2012, 11:06 AM
    ictcowboy
    Quote:

    Originally Posted by ictcowboy View Post
    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

  • All times are GMT -7. The time now is 06:48 PM.