How to Get Gross Margin in Excel. Gross margin constitutes the percent of sales that is applied to profit. As an example, if you had a 50 percent gross margin, half of the sale is profit; the ...

This is also your gross profit on each table. Divide the gross profit by the cost and multiply by 100 to calculate your percentage markup. In the example, divide $75 by $100 which equals $0.75 ...