How to calculate selling price from cost and margin

You can watch a video tutorial here.

Excel is frequently used for calculations and has many functions to help with basic mathematical operations.  When we have the cost and margin of a product, it is easy to compute the selling price using a simple formula in Excel. The formula is as follows:

Selling price = Cost + Margin %

The margin is a percentage of the cost so it changes according to the cost.

Step 1 – Enter the formula

– Select the destination cell
– Type the formula using cell references:
=Cost + (Margin% * Cost)
– Make the cell reference of the Margin % constant by selecting it and pressing F4 or by typing dollar signs in front of the row number and column header

Step 2 – Copy the formula

– Using the fill handle from the first cell, drag the formula to the remaining cells
a) Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
b) Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)