How do I determine a winning % based on wins, losses, and ties?

Looking to set up standings for my son's hockey league and need an expert to
help me set up winning percentage. Points are based on 2 for a win, 1 for a
tie, and 0 for a loss. Thanks!

(wins + ties/2)/games. Format the result as a percentage.

"rolly g" wrote:

> Looking to set up standings for my son's hockey league and need an expert to
> help me set up winning percentage. Points are based on 2 for a win, 1 for a
> tie, and 0 for a loss. Thanks!

If you put the values W/L/T in columns A:C, you could use this in column D.

=(A2+0.5*C2)/SUM(A2:C2)



rolly g wrote:
>
> Looking to set up standings for my son's hockey league and need an expert to
> help me set up winning percentage. Points are based on 2 for a win, 1 for a
> tie, and 0 for a loss. Thanks!

--

Dave Peterson

Just to make sure. If a team won 3, tied 1, and lost 1. Their percentage
would be 70% (7 points of a possible 10)? Put the numbers (2,1, or 0) in
column A and use this formula
=SUM(A1:A10)/20
where 20 is 2 times the number of games.
or
=SUM(A1:A10)/COUNT(A1:A10)/2

The second will work better if you have blank cells, to represent unplayed
games. Just remember to input lost games as 0. If you leave the lost games
blank, you will get the wrong percentage.

"rolly g" wrote:

> Looking to set up standings for my son's hockey league and need an expert to
> help me set up winning percentage. Points are based on 2 for a win, 1 for a
> tie, and 0 for a loss. Thanks!