How to calculate profit margin percentage in Excel

by

If you need to calculate a profit margin, you can easily do so with a simple formula that uses the sale price and the cost.

Worked Example:   How to get original price from percentage discount in Excel

Formula

=(price-cost)/price

Explanation

In the example shown, the first formula looks like this:

=(B4-C4)/B4

Make sure you use parentheses to control the order of operations.

Worked Example:   How to calculate percent change in Excel

Note that the result will be a decimal like 0.40, so you need to format the cell with the Percentage number format (use the ribbon or Ctrl + 1 to access all number formats).

Leave a Reply

Your email address will not be published.