Families often drop off several pairs at once, and a discount on the extra pairs encourages it. The first pair is billed at full price and every other pair is billed at the discounted price, with an average showing what each pair really cost.
Three pairs at $65 with 15% off the extra pairs cost $175.50, or $58.50 per pair.
The example
Three worked examples. Change any yellow input in the practice workbook and the results recalculate.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Case | Pairs | Price | Discount | Total | Per pair |
| 2 | One pair | 1 | $65 | 15.0% | $65.00 | $65.00 |
| 3 | Three pairs | 3 | $65 | 15.0% | $175.50 | $58.50 |
| 4 | Family | 5 | $60 | 20.0% | $252.00 | $50.40 |
The formula
Here is the formula, built directly from the inputs:
How it works
Here is the logic, one piece at a time:
C2is the full-price first pair.B2-1counts the extra pairs.(1-D2)applies the discount.E2/B2is the average cost per pair.
Keep every number in its own input cell so the formula never needs editing.
Try it: interactive demo
Enter the values below.
Variations
Tiered
Bigger discount at five pairs.
Savings
Versus no discount.
Pitfalls & errors
Zero pairs makes the formula return a negative total; validate the input.
Use the same service price for every pair or add a per-pair column.
Show the discount at the counter to encourage bundles.
Practice workbook
Frequently asked questions
Why not discount every pair?
Can I mix services?
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