Ineed to come up with an EXCEL formula for the following;
Ineed to determine the total number of games.
I know the % (games) of lost and I know the number of (game) wins.
I need to determine the total number of games.
I can figure the % of wins by subtracting the % lost from 100.
Ex 20% of games were lost
100 - 20 = 80
80 = percent won
80/100 = 30 (number of wins)
Question: If 30 wins is 80%, How many losses is 20%? How many games were there in total?
Math - helper, Wednesday, February 2, 2011 at 2:40pm
80% = 30
.80x = 30
x = 30/.80
x = 37.5 total games
20% of 37.5 = 7.5 games lost
37.5 total games
Not sure what you are trying to do in Excel.
Math - Michelle, Wednesday, February 2, 2011 at 2:44pm
Math - helper, Wednesday, February 2, 2011 at 2:50pm
You're welcome :)