ROUNDUP and ROUNDDOWN
1 / 5
How many boxes does each order need? A box that is only part full still counts as a box.
keyboard Typing formulas is easiest on a computer with a keyboard.
A1
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Units | Per box | Boxes needed | |
| 2 | Monitor Stand | 10 | 6 | ||
| 3 | Headset | 104 | 12 | ||
| 4 | Office Chair | 39 | 6 | ||
| 5 | Bookshelf | 65 | 24 | ||
| 6 | USB-C Hub | 70 | 10 | ||
| 7 | Notebook A5 | 81 | 24 | ||
| 8 | Filing Cabinet | 19 | 6 | ||
| 9 | |||||
| 10 | |||||
| 11 | |||||
| 12 |
units
per box
boxes
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
How ROUNDUP and ROUNDDOWN works
What do
ROUNDUPandROUNDDOWNdo?ROUNDgoes to the nearest value.ROUNDUPalways rounds up andROUNDDOWNalways rounds down:=ROUNDUP(2.1,0)gives 3.=ROUNDDOWN(2.9,0)gives 2.
When do you round up?
When part of one still needs a whole one: boxes, buses, rolls of paper. 25 units in boxes of 12 is 2.08, but you need 3 boxes:
=ROUNDUP(25/12,0).When do you round down?
When only whole ones count: the boxes you can fill completely, or whole weeks worked. 25 units fill 2 boxes:
=ROUNDDOWN(25/12,0).
Know someone fighting with a spreadsheet? Send them this page.