# Thread: Find a Percenage (Excel 2002)

1. ## 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

2. ## 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. ## 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

4. ## 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. ## 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.

6. ## Re: Find a Percenage (Excel 2002)

See screenshot below.

Hi Hans

Thanks