The ROUNDUP, ROUNDDOWN guide
=ROUNDUP(B2/12, 0) always rounds up to the next whole number, and =ROUNDDOWN(B2/12, 0) always down. Use them when the question decides the direction: boxes needed, vans to book, full boxes that ship.
The syntax
=ROUNDUP(number, num_digits)
=ROUNDDOWN(number, num_digits)
num_digits works as in ROUND: 0 for whole numbers, 2 for cents, -2 for hundreds. The difference is the direction. ROUND looks at the next digit; ROUNDUP and ROUNDDOWN ignore it.
When ROUND gets it wrong
50 mugs at 12 to a box is 4.17 boxes. ROUND gives 4, which leaves 2 mugs with nowhere to go. The order needs 5 boxes, so it's ROUNDUP(50/12, 0). The same 4.17 tells you how many boxes go out full: 4, so ROUNDDOWN(50/12, 0). 48 mugs fill exactly 4 boxes, and both functions give 4.
| Mugs | 50 | 55 | 48 |
|---|---|---|---|
| ÷ 12 | 4.17 | 4.58 | 4 |
| ROUND | 4 | 5 | 4 |
| ROUNDUP | 5 | 5 | 4 |
| ROUNDDOWN | 4 | 4 | 4 |
Divide first, then round
The division goes inside: ROUNDUP(B2/$G$1, 0). ROUNDUP(B2, 0)/$G$1 rounds the mugs, which are already whole, and then divides, so you get 4.17 again.
Negative numbers
ROUNDUP goes away from zero and ROUNDDOWN toward it, so ROUNDUP(-3.2, 0) is -4 and ROUNDDOWN(-3.2, 0) is -3. INT always goes down the number line: INT(-3.2) is -4. For positive numbers INT and ROUNDDOWN(…, 0) agree.
Common mistakes
- ROUND for "how many do I need". It rounds down whenever the fraction is under a half.
- 1 instead of 0 digits.
ROUNDUP(4.17, 1)is 4.2 boxes. - The box size typed in. Point at the cell and lock it,
$G$1, so a new box size updates every order.
FAQ
- How do I always round up in Excel?
- Use =ROUNDUP(number,0) for the next whole number, or another num_digits for decimals. It rounds up even when the fraction is tiny, so 4.01 becomes 5.
- What is the difference between ROUND and ROUNDUP?
- ROUND goes to the nearest value, so 4.17 becomes 4. ROUNDUP always goes away from zero, so 4.17 becomes 5.
- How do I calculate how many boxes I need in Excel?
- Divide the items by the items per box and round up: =ROUNDUP(B2/$G$1,0). CEILING(B2/$G$1,1) gives the same.
- Is ROUNDDOWN the same as INT?
- For positive numbers, ROUNDDOWN(x,0) and INT(x) agree. For negative numbers INT goes further from zero: INT(-3.2) is -4, ROUNDDOWN(-3.2,0) is -3.



































































