ROUNDUP
Rounds a number up, away from zero.
How it’s written
ROUNDUP(number, digits)Example
| A | |
|---|---|
| 1 | Boxes |
| 2 | 4.1 |
=ROUNDUP(A2,0)Result: 5
Rounds 4.1 up to 5.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it for anything you can’t buy a fraction of, such as boxes or seats.
Practice it properly
Rounding properly gives you real tasks, with your formulas tested on data you haven’t seen.