The difference is your overall profit, in this example the formula result would be $17. Input a formula in the final column to calculate the profit margin on the sale.

How to Find the Gross Margin in Excel. The term "gross margin" describes the profit achieved on sales, expressed as a percentage of the total revenue generated by the sales. Gross margin omits ...

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

Use Microsoft Excel to calculate EBITDA (earnings before interest, tax, depreciation, and amortization) profit margin.

Profit margins vary by industry and should only be compared to those of similar companies. You can use computer software, such as Microsoft Excel, to quickly calculate profit margins.