Math

posted by .

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 -

    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.

  • Math -

    ok thanks!

  • Math -

    You're welcome :)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. equation

    n represent the number of games lost, write an equation for: a) A team won three times as many games as it lost. It played a total of 52 years. b) A team won 20 games more than it lost. It played a total of 84 games. c) A team won …
  2. Calculus

    Your high school softball team has won ten games and lost five games. To get into the playoffs, your team must win at least 80% of the games that it plays. If your team wins all its remaining games, it makes the playoffs. What is the …
  3. beginning algebra

    the rays won 33 fewer games than twice as many games as they lost. the total games played was 162. how many wins and how many losses did they have?
  4. math

    Two teams play an extended series of 100 volleyball games. Team A wins the first game and then team B wins the second. The probability that a team wins each subsequent game is equal to the proportion of games that team has won so far. …
  5. math

    Two teams play an extended series of 100 volleyball games. Team A wins the first game and then team B wins the second. The probability that a team wins each subsequent game is equal to the proportion of games that team has won so far. …
  6. 5th Grade Math

    Keith played some games of chess at a tournament. He recorded the results of the games on the table shown. Game Results: Number of Games TIES 4 WINS 12 Losses 4 If Keith plays 10 more games, how many of the 10 games is he likely to …
  7. SIXTH GRADE MATH

    The ratio of wins to losses for a basketball team is 2:3. Which of the following is a possible total number of games?
  8. SIXTH GRADE MATH

    The ratio of wins to losses for a basketball team is 2:3. Which of the following is a possible total number of games?
  9. Math (Ratios and Similar Polygons)

    a baseball team played 140 regular season games. The ratio of the number of games they won to the number of games they lost was 3 - 4 how many games did they win?
  10. geomerty

    a baseball team played 161 regular season games. The ratio of the number of games they won to the number of games they lost was 4/3. how many games did they win?

More Similar Questions