ROUNDUP
Always rounds up to the number of digits you need: how many boxes, trucks or packs it takes to fit everything.
ROUNDUP(number, num_digits)- number
- What to round, for example B2/C2.
- num_digits
- How many digits to keep after the decimal point. 0 means a whole number.
Return value
The number rounded away from zero: 3.2 becomes 4, and −3.2 becomes −4.
Examples
How many boxes to order
fx
A
B
C
D
E
1
2
3
4
5
6
7
Product
Units
Fit in a box
Boxes
Mugs
130
24
Notebooks
200
50
Pens
1010
100
T-shirts
75
20
Sheet1
Details
ROUNDUP works like ROUND but ignores the next digit: 5.01 rounded to a whole number becomes 6. You need this when coming up short isn’t an option. If you have 130 items and a box holds 24, you need 6 boxes, not 5.4.
The second argument is the same as in ROUND: 0 gives a whole number, 2 keeps two digits after the decimal point.
Common mistakes
- For negative numbers, “up” means “further from zero”: −2.1 becomes −3.
- Rounding 5.4 with plain ROUND gives 5 boxes, and some of the items won’t fit.