How in Excel 10 do I create a win loss Draw/tie

Microsoft Excel 010 - complete package
March 21, 2012 at 10:35:32
Specs: Windows 7
win loss draw formula

I run a baseball league , I want to create winning percentages from the wins of a series of teams, loss for the same series, and draw/Ties = .785%

Team1 wins loss tie =win %
Team 1 7 3 1 = win %


See More: How in Excel 10 do I create a win loss Draw/tie

Report •


#1
March 21, 2012 at 13:08:47
A percentage is always calculated as the "number of some thing" divided by the "total number of things".

e.g.

  Wins    Losses      Ties    Total Games
    7        3          1         11
   7/11     3/11       1/11
   63.64%   27.27%     9%

BTW .785% is pretty small. I don't think that that is what you are looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question