Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |