Thread: How do I determine a winning % based on wins, losses, and ties?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default How do I determine a winning % based on wins, losses, and ties?
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
Reply With QuoteReply With Quote