Change percentage -> dynamically change price

[dmb41]

I have three columns with a buy price, sell price and the margin by percentage. I can change the prices and see the percentage change, but I want to change the percentage and watch buy price change, and sell price stay constant.

Help?

[oeldere]

sell price / (100% + %) = buy price

[alansidman]

You may want to use a variable table array for some what if analysis.

Here is a link on how to set it up and do it.

http://www.dummies.com/how-to/conten...-excel-21.html

Your formula to calculate the cost if the Sell Price and Margin are known is SellPrice/(1+Margin%) ie. SP=$5.00, Margin=25%
$5.00/(1+25%) = $4.00