Question: how do you calculate profit margin in excel?
Answer: Profit Margin Formula in Excel is an input formula in the final column the profit margin on sale will be calculated. ... 
=(A2-B2) The formula should read “=(A2-B2)” to subtract the cost of the product from the sale price.