View Full Version : Excel Percentage Formula
tama453
May 15, 2008, 07:55 AM
Using an Excel worksheet, what is the formula for the percentage of wins for a team. Example 2 wins and 1 loss equals what percentage of wins?
colbtech
May 15, 2008, 08:20 AM
Played 3, Won 2 Lost 1... =sum(Won/Played)*100
chancelord
Jun 21, 2008, 07:18 PM
2 wins divided by 1 loss = 5o% which is the amount of percentage in which 1 loss equals to wins.
jjwoodhull
Jun 21, 2008, 10:29 PM
You take the number of wins and divide it by the total number of games played. In this example, 2/3 = .666