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