Auto Calculate new total when changing a percentage

Hi All

I think this should be quite simple but I'm stuck!!
Basically I have three cells, Raw Materials (£), Selling Price (£), Margin (%).
At the moment the calculation is simple as you change the selling price the % margin changes with it.

However I want the Raw Materials (£) to stay Fixed, and the Selling Price(£) to automatically adjust when I enter a % value in the Margin cell.

As I said sounds simple enough... but it's baffled me!!!

Any suggestions / solutions greatfully accepted.

Thanks
DEA

Assuming
A1 = Cost
A2 = Sell Price
A3 = Profit margin (in the format 0.5) for 50%

the formula for A2 would be

Please Login or Register  to view this content.

if you want A3 to show 50%

use

Please Login or Register  to view this content.

Thanks kgkec

Slight problem though, the calculation is out...by quite a bit!!

if A1 is £1 then setting the margin at 20% should result in a sale price of £1.20, but it shows £1.25!!!
I tried £1 plus 80% and got £5 not £1.80 as it should be!?!

I've tried to play around with it but I'm not getting anywhere.

Any more ideas?

Thanks for trying I appreciate it

I think I have a tempary fix.

A1 = £1
B1 =A1*C1
C1 = 120%

give result in B1 as £1.20

trouble is you must format C1 as a percentile, and enter the percent you want pluss 100. ie you want 23% margin you need to enter 123% to get the right result.

I'm sure there must be an more effective and accurate way, so am still ope to suggestions!!

Cheers