I have developed 3 simple formulas for calculating Cost, Sell Price, and Margin.
I was wondering if there was a way to create some buttons if you will telling which value / formula to use.
Here are the formulas:
To calculate sell price = B2/(1-B3)
To calculate cost = B6*(1-B7)
To calculate margin = 1-(B10/B11)
Right now I have 3 different sets of cells, depending on what value to calculate, I fill in the variables.
I want to have just one set and then click either calc sell price, cost, or margin.
I was thinking about using a macros but was hoping there was another way.
Thanks in advance for any help.
Bookmarks