Count only whole teams with ROUNDDOWN
PremiumIn C2, work out how many full teams of B2 people you can make from the A2 people who signed up. A team that isn't full doesn't count, so use ROUNDDOWN with 0 decimals.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | People | Per team | Full teams | |||
| 2 | 40 | 6 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock ROUND, ROUNDUP and ROUNDDOWN and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
It comes up in this mock test: Excel assessment (Indeed format)
Why this works
40 / 6 is 6.67. Six teams are full and the four people left over can't make a seventh, so the answer has to be rounded down whatever the decimals are. ROUNDDOWN(number, 0) cuts them off and gives 6.
Common mistake: Using ROUND, which gives 7 because 6.67 is closer to 7. A seventh team would be two people short.
The answer
- C2
=ROUNDDOWN(1A2/B2,20)
In plain words: Round 1the people in A2 divided by the team size in B2 down to 2a whole number.