---
title: How To Calculate Gross Margin in Excel or Sheets
description: Calculate gross margin using a simple formula or pre-built function. This important metric helps track business profitability and make pricing decisions.
image: https://demandcues.com/hubfs/Blog%20Banners%20-%202024-01-26T210710.691.png
---

# How To Calculate Gross Margin in Excel or Sheets

Introduction Gross margin is a key metric for businesses of all sizes. It shows how much money is left over after ...

[ Doug Dotts ](https://demandcues.com/resources/author/doug-dotts)

 Jan 26, 2024

---

[Metrics](https://demandcues.com/resources/tag/metrics) [How To](https://demandcues.com/resources/tag/how-to) [Gross Margin](https://demandcues.com/resources/tag/gross-margin)

##### **Introduction**

Gross margin is a key metric for businesses of all sizes. It shows how much money is left over after accounting for the cost of goods sold (COGS). A high gross margin means that a business is efficient at converting sales into profit. In this blog post, we will show you how to calculate gross margin in Excel or Sheets.

##### **Why it's important**

Gross margin is important for several reasons. First, it can be used to track the profitability of a business over time. Second, it can be used to compare the profitability of different products or services. Third, it can be used to make pricing decisions.

##### **How to calculate gross margin in Excel or Sheets**

There are two ways to calculate gross margin in Excel or Sheets:

The formula for calculating gross margin is:

```
(Revenue - COGS) / Revenue
```

To use this formula, simply enter your revenue and COGS figures into two separate cells. Then, in a third cell, enter the formula above. For example, if your revenue is $100 and your COGS is $70, your gross margin would be 30%.

Excel and Sheets both have pre-built functions that can be used to calculate gross margin. The function in Excel is called GROSSMARGIN, and the function in Sheets is called GROSSMARGIN. To use these functions, simply enter your revenue and COGS figures into the function's arguments.

##### **Summary**

Calculating gross margin is a simple process that can be done in Excel or Sheets using a formula or a pre-built function. Gross margin is an important metric that can be used to track the profitability of a business, compare the profitability of different products or services, and make pricing decisions.

## Discover More

<https://demandcues.com/resources/how-to-calculate-total-revenue-in-excel-or-sheets>

Metrics

##### [How To Calculate Total Revenue in Excel or Sheets](https://demandcues.com/resources/how-to-calculate-total-revenue-in-excel-or-sheets)

<https://demandcues.com/resources/how-to-calculate-average-order-value-aov-in-excel-or-sheets>

Metrics

##### [How To Calculate Average Order Value (AOV) in Excel or Sheets](https://demandcues.com/resources/how-to-calculate-average-order-value-aov-in-excel-or-sheets)

<https://demandcues.com/resources/how-to-calculate-revenue-growth-rate-in-excel-or-sheets>

Metrics

##### [How To Calculate Revenue Growth Rate in Excel or Sheets](https://demandcues.com/resources/how-to-calculate-revenue-growth-rate-in-excel-or-sheets)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Doug Dotts",
    "url" : "https://demandcues.com/resources/author/doug-dotts"
  },
  "dateModified" : "2024-01-29T06:41:32.104Z",
  "datePublished" : "2024-01-26T13:07:29.000Z",
  "headline" : "How To Calculate Gross Margin in Excel or Sheets",
  "image" : [ "https://demandcues.com/hubfs/Blog%20Banners%20-%202024-01-26T210710.691.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://demandcues.com/resources/how-to-calculate-gross-margin-in-excel-or-sheets",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://demandcues.com/hubfs/DC%20Dark%2026.png"
    },
    "name" : "Demand Cues"
  }
}
```