Question

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?

Answer 1

80% = 30

.80x = 30
x = 30/.80
x = 37.5 total games

20% of 37.5 = 7.5 games lost

30 wins
7.5 lost
37.5 total games

Not sure what you are trying to do in Excel.

Answer 2

ok thanks!

Answer 3

You're welcome :)