Use the Formula in D2 cell 1- B2C2 As you can see in the above snapshot first data percentage of profit margin is 8. How Do You Calculate Gross Profit Percentage. Profit Percentage Net Profit Cost.
Then multiply the resulting figure by 100 to get your net profit margin as a percentage.
To calculate your gross profit subtract the cost of goods sold. How Do You Calculate Gross Profit Percentage. To calculate the percentage of a specific number you first convert the percentage number to a decimal. Take the selling price and subtract the initial purchase price.