Help required for calculating profit margins please.

Hi All,
second request this morning please.I have a price list and need to calculate the selling price making
35%profit
40%profit
45%profit
Anyone able to help me please.
Thanks in advance.

Try

=ROUND(price*(1+35%),2)

etc.

Originally Posted by Bob Phillips

Try

=ROUND(price*(1+35%),2)

etc.

Hi Bob,
thanks for the speedy reply. What I need to do is not to add 35% (etc) on, but to end up with a price which would be giving a 35% margin, so the value would be circa £4.76. Does that make sense?

Hi Allgermanparts

How about
=ROUND((Price*Profit%)/(1+Profit%),2)

=cost/(1-margin%)

Hi Guys,
thanks for these-I'll try when work gets a bit quieter

This should give you the sales price

=ROUND(cost_price/(1-profit),2)