Tuition varies by age group (infants cost most) and schedule (full vs part time). A rate table by age, scaled for part-time days, produces each family’s tuition.
The example
Infant full-time = $320/wk.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Infant rate | $320 |
| 3 | 3-day part time | → $192 |
The formula
The formula:
How it works
How it works:
- Build a rate table: age group → full-time weekly rate.
- VLOOKUP the age group (exact match) for the base rate.
- For part time, scale by days:
full_rate × days ÷ 5(or use a part-time column). - Add a schedule lookup for non-linear part-time pricing if rates aren’t proportional.
Part-time rarely scales linearly — decide your policy. A 3-day week often costs more than 3/5 of full-time because fixed costs (a licensed spot, ratios) don’t shrink proportionally. You can scale by days for simplicity, or keep a separate part-time column in the rate table for true pricing. Either way, a single VLOOKUP on age group plus a schedule rule produces consistent tuition for every family.
Try it: interactive demo
Age group rate and days per week.
Variations
Part-time by days
Scale full rate:
Part-time column
Non-linear:
Monthly tuition
Weekly × 52 / 12:
Pitfalls & errors
Exact match. Age group names need FALSE in VLOOKUP.
Part-time policy. Decide linear scaling vs a separate rate.
Weekly to monthly. Use ×52÷12, not ×4, for an accurate month.
Practice workbook
Frequently asked questions
How do I look up childcare tuition by age in Excel?
How do I price part time?
How do I convert weekly to monthly?
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