Selling Price Formula in Excel

The selling price is the amount a customer pays to buy a product or service. We show you how to calculate a product’s selling price using the selling price formula in Excel.

How to calculate the selling price of a product in Excel

We will use the following dataset to explain how the selling price formula in Excel works.

We use the following steps:

  1. Select cell C2 and type in the following formula:
Table

Description automatically generated
  1. Press Enter and double-click or drag down the fill handle to copy the formula down the column.
Table, Excel

Description automatically generated

Explanation of the formula

The generic formula for calculating the profit margin is:

Margin % = 1- (Selling Price/Cost)

The generic formula for calculating the selling price is, therefore:

Selling Price = Cost/(1-Margin%)

Conclusion

The generic formula for calculating the selling price from cost and margin is:

Selling Price = Cost/(1-Margin%)

This tutorial showed the application of the selling price formula in Excel.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.