ExcelHeroThe ROUNDUP function
Always rounds away from zero.
In German Excel: AUFRUNDEN
How to write it
=ROUNDUP(number, num_digits)- number
- The number to round.
- num_digits
- Digits to keep.
💡 Great for “how many boxes do I need?”.
Try it
10 items fit in a box. How many boxes do you need for 53 items?
A
B
1
Items
53
2
Per box
10
3
Boxes
You can’t ship half a box: always round up.