Help! Margin / Sell price Calculator

Hi All,

I am building a budget template and I am trying to calculate either Margin or Sell, ie if user inputs margin- the sell price calculates or if user inputs sell price- the margin will calculate (based on budget price).

Here are the formulas
If Margin is entered: Sell = Cost/(1-Margin)
If Sell is entered:Margin = (cost-sell)/sell

Capture.JPG
Is there any way to do this up in VBA where the sell can do these calculations?

Thank you very much. Worked like a charm!