Divide this result by the total revenue to calculate the gross profit margin in Excel. Generally a gross profit margins calculator would rephrase this equation and simply divide the total gross profit dollar amount we mentioned above by the net sales. To calculate of Sales for each month you need to do the following.
How to calculate the extra charge in percentage if you know the margin.
Also to calculate profit percentage in excel type profit percentage formula of Excel ie. Last year a company had a gross margin of 20 percent. A2-B2 into C2 the profit cell. To calculate of Sales for each month you need to do the following.