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:
=B2/(1-$B$9)
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

=B2/(1-$B$9)

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.