| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with formula
Hi All,
Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Hi Bill,
Look at ToolsGoal Seek Post again in this same thread if you can't get it done -- Kind regards, Niek Otten Microsoft MVP - Excel "bp" wrote in message ... | Hi All, | Running Win98SE :-( and Excel 2000. | Is it possible to get assistance with the following formula. | I am currently determining the Profit Margin Percent with the following | ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % | OR | =((20.7-12)-(12*.24867))/20.7=27.61% | I then have to play with the billrate to get a number close to 30%. | Is there a way to rework the formula by plugging in the 30% and working out | the BillRate? | Thanks | Bill | | |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Hi Niek,
Thanks for your solution. I was looking for a formula to accomplish the same result but giving me the rate instead of the profit margin %. Can you think of a way to accomplish this with a formula change? Thanks again for you solution. Bill "Niek Otten" wrote in message ... Hi Bill, Look at ToolsGoal Seek Post again in this same thread if you can't get it done -- Kind regards, Niek Otten Microsoft MVP - Excel "bp" wrote in message ... | Hi All, | Running Win98SE :-( and Excel 2000. | Is it possible to get assistance with the following formula. | I am currently determining the Profit Margin Percent with the following | ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % | OR | =((20.7-12)-(12*.24867))/20.7=27.61% | I then have to play with the billrate to get a number close to 30%. | Is there a way to rework the formula by plugging in the 30% and working out | the BillRate? | Thanks | Bill | | |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
=((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "bp" wrote in message ... Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
On Sat, 22 Jul 2006 18:49:57 +0100, Sandy Mann
wrote: =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? Both 20.7 need to change :) -- Steve (3) |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Hi Sandy,
Thanks for your reply If I may go back, the formula below is actual. It works. But I must adjust the 20.7 until I achieve the 30% instead of the 27.61% displayed. =((20.7-12)-(12*.24867))/20.7=27.61% I need to try to establish a new equation to find X below =((X-12)-(12*.24867))/X=30.00 Hope this makes sense Can you help? Thanks Bill "Sandy Mann" wrote in message ... =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "bp" wrote in message ... Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Correct.
Thanks Bill "SteveW" wrote in message news:op.tc3rfcnnevjsnp@enigma03... On Sat, 22 Jul 2006 18:49:57 +0100, Sandy Mann wrote: =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? Both 20.7 need to change :) -- Steve (3) |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Re-working original formula
((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % Billrate = ((PayRate*Fringe)+PayRate)/(1-Profit Margin%) BillRate = ((12*0.24867)+12)/(1-0.30) = 21.405 % verify with original figures BillRate = ((12*0.24867)+12)/(1-0.2761) = 20.7 % On Sat, 22 Jul 2006 19:27:21 +0100, bp wrote: Hi Sandy, Thanks for your reply If I may go back, the formula below is actual. It works. But I must adjust the 20.7 until I achieve the 30% instead of the 27.61% displayed. =((20.7-12)-(12*.24867))/20.7=27.61% I need to try to establish a new equation to find X below =((X-12)-(12*.24867))/X=30.00 Hope this makes sense Can you help? Thanks Bill "Sandy Mann" wrote in message ... =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "bp" wrote in message ... Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill -- Steve (3) |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
Steve...............
You are the man. I could not get my old mind around that formula. It works like a dream! Thank you so much. Thanks to all that responded. You folks are the greatest! Bill "SteveW" wrote in message news:op.tc3tm8stevjsnp@enigma03... Re-working original formula ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % Billrate = ((PayRate*Fringe)+PayRate)/(1-Profit Margin%) BillRate = ((12*0.24867)+12)/(1-0.30) = 21.405 % verify with original figures BillRate = ((12*0.24867)+12)/(1-0.2761) = 20.7 % On Sat, 22 Jul 2006 19:27:21 +0100, bp wrote: Hi Sandy, Thanks for your reply If I may go back, the formula below is actual. It works. But I must adjust the 20.7 until I achieve the 30% instead of the 27.61% displayed. =((20.7-12)-(12*.24867))/20.7=27.61% I need to try to establish a new equation to find X below =((X-12)-(12*.24867))/X=30.00 Hope this makes sense Can you help? Thanks Bill "Sandy Mann" wrote in message ... =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "bp" wrote in message ... Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill -- Steve (3) |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with formula
ta for the feedback.
On Sat, 22 Jul 2006 21:27:17 +0100, bp wrote: Steve............... You are the man. I could not get my old mind around that formula. It works like a dream! Thank you so much. Thanks to all that responded. You folks are the greatest! Bill "SteveW" wrote in message news:op.tc3tm8stevjsnp@enigma03... Re-working original formula ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % Billrate = ((PayRate*Fringe)+PayRate)/(1-Profit Margin%) BillRate = ((12*0.24867)+12)/(1-0.30) = 21.405 % verify with original figures BillRate = ((12*0.24867)+12)/(1-0.2761) = 20.7 % On Sat, 22 Jul 2006 19:27:21 +0100, bp wrote: Hi Sandy, Thanks for your reply If I may go back, the formula below is actual. It works. But I must adjust the 20.7 until I achieve the 30% instead of the 27.61% displayed. =((20.7-12)-(12*.24867))/20.7=27.61% I need to try to establish a new equation to find X below =((X-12)-(12*.24867))/X=30.00 Hope this makes sense Can you help? Thanks Bill "Sandy Mann" wrote in message ... =((20.7-12)-(12*.24867))/20.7=27.61% so by transposition =((20.7-12)-(12*.24867))/30%=19.0532 therefore =((20.7-12)-(12*.24867))/19.0532=30% is that what you are looking for? -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "bp" wrote in message ... Hi All, Running Win98SE :-( and Excel 2000. Is it possible to get assistance with the following formula. I am currently determining the Profit Margin Percent with the following ((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin % OR =((20.7-12)-(12*.24867))/20.7=27.61% I then have to play with the billrate to get a number close to 30%.. Is there a way to rework the formula by plugging in the 30% and working out the BillRate? Thanks Bill -- Steve (3) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
