What it does
The difference from ROUND is the direction: ROUNDDOWN simply drops whatever comes after the chosen digit. =ROUNDDOWN(11.96,0) gives 11 and =ROUNDDOWN(3.14159,2) gives 3.14. A negative num_digits works to the left of the decimal point: =ROUNDDOWN(48760,-2) is 48,700.
It suits calculations where you must not overshoot: how many full boxes a stock fills, how many units a budget buys, dropping the fractions of a penny in a currency conversion. With negative numbers it also moves towards zero: =ROUNDDOWN(-2.7,0) gives -2.
ROUNDDOWN and TRUNC give the same result; in TRUNC the digits argument is optional. INT, on the other hand, takes negative numbers down to the next lower whole number (-3 for -2.7). To round down to a multiple, use FLOOR.MATH.
Syntax
=ROUNDDOWN(number, num_digits)=AŞAĞIYUVARLA(sayı; basamak)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number to round, or a formula that produces it, e.g. B2/C2. |
num_digits | Required | The number of decimal digits to keep. 0 rounds to a whole number; negative values round to the tens and hundreds. |
Examples
1How many full boxes a stock fills
Column D divides the stock by the box size and rounds down, counting the full boxes. Column E finds the items that do not fit into full boxes.
=ROUNDDOWN(B2/C2,0)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Stock Qty | Box Size | Full Boxes | Left Over |
| 2 | Notebook | 287 | 24 | 11 | 23 |
| 3 | Pen | 1200 | 100 | 12 | 0 |
| 4 | Binder | 95 | 12 | 7 | 11 |
| 5 | Eraser | 517 | 48 | 10 | 37 |
- D2 (filled down to D5)
=ROUNDDOWN(B2/C2,0) - E2 (filled down to E5)
=B2-D2*C2
287 notebooks are not enough to fill 12 boxes; there are 11 full boxes and 23 items left to pack separately. The pen stock fills exactly 12 boxes with nothing left over.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Drop the fractions when converting currency
The euro amount is multiplied by a sample exchange rate. Column D cuts the result at two decimals without rounding the last digit up; column E drops the decimals entirely with num_digits 0.
=ROUNDDOWN(B2*C2,2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Invoice | Amount (EUR) | Rate | Converted | Whole Units |
| 2 | F-3301 | 1,250.40 | 44.8732 | 56,109.44 | 56,109 |
| 3 | F-3302 | 380.00 | 44.8732 | 17,051.81 | 17,051 |
| 4 | F-3303 | 9,725.65 | 44.8732 | 436,421.03 | 436,421 |
- D2 (filled down to D4)
=ROUNDDOWN(B2*C2,2) - E2 (filled down to E4)
=ROUNDDOWN(B2*C2,0)
F-3301 converts to 56,109.44; with ROUND, the last digit would have gone up. In whole units it is 56,109.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- One less than expected
Cause: Because of earlier calculations, the number is stored as 11.9999999 instead of 12, and rounding down gives 11.
Fix: Round it to a few decimals with ROUND first:
=ROUNDDOWN(ROUND(B2,6),0).- #VALUE!
Cause: number or num_digits is text that cannot be read as a number.
Fix: Make sure the cells really hold numbers.
Good to know
- The whole number of units a budget buys:
=ROUNDDOWN(B2/C2,0), with the budget in B2 and the unit price in C2. - For the items left over after full boxes, subtract the full boxes from the total:
=B2-ROUNDDOWN(B2/C2,0)*C2; MOD gives the same result.
In Nexell
Get Nexell to do it from a sentence
Add two columns to the stock list showing how many full boxes the current quantity fills and how many items are left over
Convert to tableBring your stock list into the tool and type this. Nexell adds both columns with real Excel formulas and shows them in the preview; in the downloaded file, the box count changes when the stock does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between ROUNDDOWN and TRUNC?
They give the same result; both cut off the dropped part and move towards zero. The difference is the syntax: in ROUNDDOWN the digits argument is required, while in TRUNC it defaults to 0.