KB ID 0001835
Problem
Occasionally at work I need to work out what the sale price / retail price will be for something would be (given that I know the cost and the % margin). That’s easy to work out. But sometimes I get given the sell / retail price and I know the margin used, and I then must work out what the cost will be.
Ordinarily if it’s a quick question I’ll just use and online margin calculator. But if I have a LOT of items to price – then Excel is the way to go.
Solution: Working out the Sell Price
If you know the cost and the margin to be applied, this is how to work out the retail price.
Solution: Working out the Cost Price
If you know the retail (Sell) price and the that was applied, this is how to work out the cost price.
Related Articles, References, Credits, or External Links
Special thanks to Mr Andrew Dorrian, who worked out the formula for the ‘cost price’ while I swore a lot!
Excel – IP Address Formula for ‘Auto fill’
Excel – Creating a Dropdown Box ‘From data on another sheet’