How do i calculate margin cost

[i8ur4re]

My spreadsheet looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD] Total Collected After Shipping & Fees


[/TD]
[TD] Amber List Cost


[/TD]
[TD] Estimated Profit


[/TD]
[TD]Profit Margin


[/TD]
[/TR]
[TR]
[TD]$50.36[/TD]
[TD]40.00[/TD]
[TD]10.36[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]$13.35[/TD]
[TD]10.00[/TD]
[TD]3.35[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]


How do i calculate the profit margin?

 

[Scott T]

Gross profit margin = (Net sales-Cost of goods sold)/ net sales

Book1
	A	B	C	D
3	50.36	40	10.36	21%
4	13.35	10	3.35	25%
Sheet2

Cell Formulas
Range	Formula
C3	=A3-B3