A couple of years ago, I blogged about the difference between margin and markup. Since then, there have been a number of occasions when I’ve wanted to know the formula to take two cells in Excel, one with a cost and the other with a margin percentage, and then calculate the price. I’m sure I’ve blogged that too, but I can’t find it now – so here it is (after I worked it out again this afternoon)…
Using the example above, the formula to calculate the price in cell C2, based on cost in A2 and margin in B2 is =A2/(1-B2)
.