ROUNDDOWN
Rounds a number down, toward zero.
How it’s written
ROUNDDOWN(number, digits)Example
| A | |
|---|---|
| 1 | Value |
| 2 | 4.9 |
=ROUNDDOWN(A2,0)Result: 4
Rounds 4.9 down to 4.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Useful for complete units, such as whole years of service.
Practice it properly
Rounding properly gives you real tasks, with your formulas tested on data you haven’t seen.