['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.']