ƒx SheetOps
ƒx

Excel Gross Margin Formula

finance Difficulty:
One-Click Copy
(Revenue - COGS) / Revenue

Quick context

  • • Works in both Excel and Google Sheets.
  • • Use when you need consistent, auditable results.
  • • Copy the snippet above and adjust only the ranges.

When to use

Calculates the percentage of revenue that exceeds the cost of goods sold.

Determine the profitability of your products.

Calculate Gross Margin

Determine the profitability of your products.

Inputs

  • Revenue Total sales revenue.
  • COGS Cost of Goods Sold.

Practical Example

=(200 - 120) / 200

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.