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