Results 1 to 7 of 7
Thread: Find a Percenage (Excel 2002)

20050518, 07:45 #1
 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
BraddyIf you are a fool at forty, you will always be a fool

20050518, 07:50 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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...

20050518, 08:15 #3
 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
BraddyIf you are a fool at forty, you will always be a fool

20050518, 08:22 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 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.

20050518, 08:30 #5
 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 BraddyIf you are a fool at forty, you will always be a fool

20050518, 08:36 #6
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Find a Percenage (Excel 2002)
See screenshot below.

20050518, 08:51 #7
 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.
BraddyIf you are a fool at forty, you will always be a fool