how to calculate gross profit ratio in excel?
Enter "=(A1-B1)/A1" in cell C1 to calculate gross margin in decimal format. As an example, if total revenue was $150 million and total costs were $90 million, then you would get 0.4.