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?
Bookmarks