In this article:

Profit Margin Formula in Google Sheets (How to Calculate in 2024)

May 8, 2024

Profit Margin Formula in Google Sheets

Profit margin is a financial metric used to assess a company's financial health by calculating the percentage of revenue that exceeds the company's costs and expenses. In simpler terms, it shows what percentage of sales has turned into profits.

To calculate profit margin in Google Sheets, you can use the following formula:

=(Revenue - Cost) / Revenue

How to Calculate Profit Margin in Google Sheets

Follow the steps below to calculate profit margin in Google Sheets. 

1. Enter the Revenue and Cost Data Into Columns

Enter your Revenue and Cost data into two separate columns in Google Sheets. For this dataset, you might label the first column "Product", the second column "Revenue ($)", and the third column "Cost ($)".

profit margin formula google sheets

2. Click on the Cell Next to First Data Row for Profit Calculation

Click on the cell right next to the first row of your data (for example, D2, if your data starts at row 2) where you want the profit margin result to appear.

how to calculate profit margin in google sheets

3. Type the Profit Margin Formula in the Selected Cell

Type the formula to calculate the profit margin based on your Revenue and Cost. Given your Revenue is in column B and your Cost is in column C, for the first product (Product A in row 2), the formula in cell D2 would be =(B2 - C2) / B2.

google sheets profit margin formula

4. Press Enter to Display Profit Margin as Decimal

After typing the formula, press Enter. Cell D2 will display the profit margin for Product A as a decimal. To see this as a percentage, move to the next step.

profit margin google sheets

5. Format Decimal Profit Margin as Percentage

With cell D2 still selected, go to Format > Number > Percent in the Google Sheets menu. This will convert the decimal in cell D2 to a percentage.

6. Drag Fill Handle Down to Calculate Profit Margins for All Products

To calculate the profit margin for Products B through J, drag the fill handle (the small square at the bottom right corner of cell D2) down through cell D11. Google Sheets will automatically adjust the formula for each product.

7. Review Calculated Profit Margins for Each Product

Examine the calculated profit margins in column D for each product. These percentages reveal the portion of revenue that is profit for each product.

We hope that you now have a better understanding of how to calculate profit margin in Google Sheets. If you enjoyed this article, you might also like our article on how to use the Google Sheets inflation formula or our article on how to create a commission tracker in Google Sheets. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->