Families with multiple children get a sibling discount — often a percentage off the second (and later) child. Summing each child’s tuition with the right discount gives the family total.
The example
$320 + $280, 10% off 2nd.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 320 + 280×0.9 | — |
| 3 | Family total | → $572 |
The formula
The formula:
How it works
How it works:
- Charge the first child (usually the highest tuition) at full rate.
- Apply the discount to each additional child’s tuition.
- For many children,
SUMPRODUCT(tuitions, discount_factors)handles it in one cell. - Decide whether the discount applies to the oldest or the lowest tuition — it changes the total.
Which child gets the discount matters. Discounting the second-enrolled child versus the lowest-tuition child gives different family totals — and since infant tuition is highest, applying the discount to the cheaper preschool spot costs the family more. State the rule clearly and encode it consistently. A discount-factor column (1.0 for full, 0.9 for discounted) plus SUMPRODUCT makes any policy a one-cell calc.
Try it: interactive demo
First child tuition, others total, discount %.
Variations
Many children
Discount factors:
Amount saved
The discount:
Flat per-sibling discount
Dollar, not percent:
Pitfalls & errors
Which child. Discount the second-enrolled or the lowest tuition — decide and document.
Percent as decimal. 10% is 0.10.
Per child. Apply the discount per additional child, not once.
Practice workbook
Frequently asked questions
How do I calculate a sibling discount in Excel?
How do I handle many children?
Which child should get the discount?
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