Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Find a Percenage (Excel 2002)

    Hi

    If I take 29 minus 4 and divide by 29.00 this gives me 86.21%

    Is there a way I can get X minus 4.00 and divide by x to = 55% where X is the figure I need.

    I'm sorry if this not very clear but I don't know how else to explain it. Other than to say 29 is the list price - 4 is the cost price which gives me a price of 25 I need to set a minimum price of 55% of 25

    Can this be done in one formula/
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find a Percenage (Excel 2002)

    This is a math excercise:

    (x - 4) / x = 0.55 (remember that 55% = 55/100)
    1 - 4 / x = 0.55
    4 / x = 1 - 0.55
    4 / x = 0.45
    x = 4 / 0.45 = 8.8888...

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Find a Percenage (Excel 2002)

    Hi Hans

    Sorry to be so dumb In your math exercise you say (x - 4) / x = 0.55

    but if x = 29 I get 86.21% what am I missing here.


    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find a Percenage (Excel 2002)

    I thought that you wanted to find the value of x for which x - 4 divided by x results in 55%. The solution is obviously not x = 29, for as you state correctly, this results in 25 / 29 = 0.86... or 86%.

    I showed how you can rework the equation to find x. If that is not what you wanted, please try to explain again what you want to accomplish.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Find a Percenage (Excel 2002)

    Hi Hans

    You are correct when you thought I wanted to find the value of x but I don't understand how to apply your formula.

    Thanks Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find a Percenage (Excel 2002)

    See screenshot below.

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Find a Percenage (Excel 2002)

    Hi Hans

    Thanks

    Sorry to try your patience.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •