ROUNDDOWN
Always rounds down by dropping the extra digits: how many whole items fit in a budget, how many complete sets you can put together.
ROUNDDOWN(number, num_digits)- number
- What to round, for example B2/C2.
- num_digits
- How many digits to keep after the decimal point. 0 means a whole number.
Return value
The number with the extra digits dropped, that is, rounded toward zero: 3.9 becomes 3, and −3.9 becomes −3.
Examples
How many gifts fit in the budget
fx
A
B
C
D
E
1
2
3
4
5
6
7
Department
Budget, $
Gift price, $
Gifts
Sales
50000
1790
Accounting
15000
1790
Warehouse
32000
1790
IT
21480
1790
Sheet1
Details
ROUNDDOWN simply cuts off the digits past the place you need: 27.93 rounded to a whole number becomes 27. Use it when a partial result doesn’t count. If the money covers 27.93 gifts, you can only buy 27.
The second argument is the same as in ROUND: 0 gives a whole number, 1 keeps one digit after the decimal point.
Common mistakes
- ROUNDDOWN rounds negative numbers toward zero: −2.7 becomes −2. INT gives −3 in the same case.
- Changing the cell format to show no decimals doesn’t drop digits; it rounds them on screen by the usual rules, so 27.93 shows up as 28.