ROUNDDOWN Function
Rounds a number down, towards zero.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Overview
ROUNDDOWN always rounds towards zero, simply cutting off the extra digits: 2.99 becomes 2.
It's the right choice for “how many complete…”: full boxes you can fill, whole years of service, completed hours.
Syntax
=ROUNDDOWN(number, num_digits) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to round. |
| num_digits | Yes | Decimal places; 0 for whole numbers, negative for tens, hundreds… |
Examples
Example 1 — Full boxes
How many full 12-unit boxes can we pack?
C2fx=ROUNDDOWN(B2/12, 0)
| A | B | C | |
|---|---|---|---|
| 1 | Batch | Units | Full boxes |
| 2 | A | 30 | 2 |
| 3 | B | 24 | 2 |
| 4 | C | 49 | 4 |
=ROUNDDOWN(B2/12, 0) Explain
Example 2 — Commission to the cent, never rounded up
Pay commission without ever rounding in the rep's favour.
=ROUNDDOWN(B2*3.5%, 2) Explain
Common mistakes
- Same as TRUNC. ROUNDDOWN(x, 0) and TRUNC(x) give the same answer; INT differs for negative numbers.
Notes
- Related functions: ROUNDUP, ROUND, TRUNC, INT, FLOOR.MATH.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.