Get profit margin percentage

Get profit margin percentage


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.

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


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

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

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas