Post a New Question

Math

posted by on .

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 :)

Answer This Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Post a New Question