 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Help 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 Hi Bill, Look at Tools>Goal Seek Post again in this same thread if you can't get it done  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Hi All, | Running Win98SE :-( and Excel 2000. [quoted text clipped - 8 lines] | Thanks | Bill 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 > Hi Bill, > [quoted text clipped - 14 lines] > | Thanks > | Bill > =((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? SignatureHTH Sandy In Perth, the ancient capital of Scotland sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Hi All, > Running Win98SE :-( and Excel 2000. [quoted text clipped - 9 lines] > Thanks > Bill >> =((20.7-12)-(12*.24867))/20.7=27.61% > [quoted text clipped - 7 lines] > > is that what you are looking for? Both 20.7 need to change :) SignatureSteve (3) Correct. Thanks Bill On Sat, 22 Jul 2006 18:49:57 +0100, Sandy Mann <sandymann2@mailinator.com> wrote: >> =((20.7-12)-(12*.24867))/20.7=27.61% > [quoted text clipped - 7 lines] > > is that what you are looking for? Both 20.7 need to change :) SignatureSteve (3) 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 > > =((20.7-12)-(12*.24867))/20.7=27.61% > [quoted text clipped - 20 lines] > > Thanks > > Bill 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 % > Hi Sandy, > Thanks for your reply [quoted text clipped - 45 lines] >> > Thanks >> > Bill SignatureSteve (3) 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 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 % > Hi Sandy, > Thanks for your reply [quoted text clipped - 45 lines] >> > Thanks >> > Bill SignatureSteve (3) ta for the feedback. > Steve............... > You are the man. I could not get my old mind around that formula. [quoted text clipped - 60 lines] >>> > Thanks >>> > Bill SignatureSteve (3)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.