Licensing rules cap how many children one adult can supervise. A quick formula turns a head count into the staff you must have on the floor — and flags shortfalls.
Compare required staff to staff present to catch a room that is out of ratio.
The example
A toddler room allows 4 children per staff member and has 11 children present.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Children | 11 |
| 3 | Max per staff | 4 |
| 4 | Staff required | 3 |
The formula
Children divided by the ratio, rounded up, gives the minimum staff needed:
How it works
The logic:
- Enter the number of children in the room (11) and the licensed maximum per staff member (4).
- Divide: 11 ÷ 4 = 2.75 staff. You cannot have a fraction of a person.
- ROUNDUP forces 2.75 up to 3 — three staff are required to stay in ratio.
- Compare staff required to staff present; if present is fewer, the room is out of compliance.
Wrap a status check around it so the sheet says "Short 1" the moment a room dips below ratio.
Try it: interactive demo
Enter children, the licensed ratio, and staff present; see required staff and compliance.
Variations
Status label
Turn the comparison into a plain message.
Max children for current staff
Flip it: how many children this many staff can cover.
Pitfalls & errors
Never use ROUND or ROUNDDOWN here — rounding 2.75 down to 2 would put the room out of ratio and out of compliance.
Ratios usually change by age group and by mixed-age rooms. Keep a ratio per room rather than one shop-wide number.
Practice workbook
Frequently asked questions
Why round up instead of to nearest?
Do ratios differ by age?
Can it warn me before I am short?
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