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?
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.
ok thanks!
You're welcome :)
To determine the total number of games, you can use the information provided about the percentage of wins and the number of wins. Here's the step-by-step process to calculate the total number of games:
1. Calculate the percentage of losses:
If 30 wins represent 80% of the total games, you can subtract this percentage from 100 to find the percentage of losses:
100 - 80 = 20% (Percentage of losses)
2. Convert the percentage into the actual number of losses:
Since you know that 20% of the games were lost, and you want to find the number of losses, you can multiply the percentage by the total number of games.
Let's denote the total number of games as "G":
(20/100) * G = Number of losses
3. Substitute the value of 30 wins to find the total number of games:
Since you already know that the number of wins is 30, you can set up an equation to find the value of "G":
Number of wins + Number of losses = Total number of games
30 + (20/100) * G = G
To solve this equation for "G" (the total number of games), you'll need to rearrange it and then solve for the unknown variable. Subtracting 30 from both sides of the equation gives:
(20/100) * G = G - 30
Finally, solve for "G":
(20/100) * G = G - 30
20G = 100G - 3000
100G - 20G = 3000
80G = 3000
G = 3000 / 80
G = 37.5
Therefore, the total number of games played is 37.5 (which means it's a fractional value, so you might consider rounding it up or down depending on the context).