Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate gross margin in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=(B2-A2)/B2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Cost | Price |
| 60 | 100 |
=(B2-A2)/B2→0.4
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Subtract cost from price to get profit: B2-A2.
- 2Divide by the price (B2) — margin is relative to revenue, not cost.
- 3Format as a percentage to read it (e.g. 0.4 = 40%).
Tips
- Markup divides by cost; margin divides by price — don't mix them up.
- Use IFERROR to handle rows where price is blank or zero.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What's the difference between margin and markup?
Margin is profit ÷ price; markup is profit ÷ cost. The same dollar profit gives a smaller margin than markup.
More on Finance basics
See all →How-to
How to calculate compound interest
Calculate a compounded closing balance from principal, annual nominal rate, compounding frequency and years, then separate the interest earned.
How-toHow to calculate the effective annual interest rate
Convert a positive nominal annual rate and a whole-number compounding frequency into an effective annual rate with EFFECT.
How-toHow to calculate the break-even point in units
Divide fixed costs by unit contribution margin and round up to whole units, with an explicit message when the margin is nonpositive.
How-toHow to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate net pay
Calculate take-home (net) pay by subtracting every deduction from gross salary, with worked examples for fixed amounts, percentage tax, and slab-based tax. Excel and Google Sheets.
How-toHow to calculate cost per unit
Divide total cost by total units to find cost per unit using a simple formula in Excel or Google Sheets.