Return rate — refunds over orders (or returned units over sold) — eats into revenue and signals product or expectation problems. Net revenue subtracts the refunds.
The example
9 refunds of 120 orders.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Refunds | 9 |
| 3 | Orders | 120 → 7.5% |
The formula
The formula:
How it works
How it works:
- Divide refunds (or returns) by orders for the rate — by count or by dollars.
- By dollars:
refund_amount / gross_revenue; net revenue = gross − refunds. - High returns flag sizing, quality, or description issues — segment by product to find the culprit.
- Returns carry hidden cost — shipping and restocking on top of the lost sale.
Segment to find the cause. A blended 7.5% return rate hides that one product returns at 30% (a sizing problem) while the rest are fine. COUNTIFS by SKU or category surfaces the offenders — fixing a description or size chart on one item can cut the overall rate more than any store-wide effort.
Try it: interactive demo
Refunds, orders, gross revenue.
Variations
By dollars
Value-based:
Net revenue
After refunds:
By product
Find the culprit:
Pitfalls & errors
Count vs dollars. A few high-value returns hurt revenue more than many small ones.
Hidden costs. Returns add shipping and restocking beyond the lost sale.
Segment by SKU. One bad product can dominate the blended rate.
Practice workbook
Frequently asked questions
How do I calculate return rate in Excel?
How do I find net revenue after returns?
How do I find which product drives returns?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class