Tuesday's mental block..

[frxianda]

Hi there,
I'm trying to find an easy formula but I'm stuck with that..
I want to input manually my profit and the margin coefficient and calculate automatically the costs and sales as in the picture enclosed.
Meaning I want to know how much it's going to cost me if I want a specific target margin with a specific margin coefficient.
Then I can just change the profit and coefficient to create different hypothesis easily.
Hope it's clear. If anyone has any idea, that would save my day Thanks!

 

[frxianda]

Here is the screenshot of my spreasheet