View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
bp bp is offline
external usenet poster
 
Posts: 5
Default 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