Skip to content

Excel function · Math

Excel ROUNDDOWN function

ROUNDDOWN always rounds a number down, towards zero, to the number of digits you give, whatever the part being dropped: 11.96 boxes become 11 full boxes. Use it for completed quantities and figures that must not exceed a limit.

In Turkish Excel: AŞAĞIYUVARLA

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

English Excel=ROUNDDOWN(number, num_digits)
Turkish Excel=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

ArgumentRequiredDescription
numberRequiredThe number to round, or a formula that produces it, e.g. B2/C2.
num_digitsRequiredThe 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.

D2fx=ROUNDDOWN(B2/C2,0)
How many full boxes a stock fills: example table
ABCDE
1ItemStock QtyBox SizeFull BoxesLeft Over
2Notebook287241123
3Pen1200100120
4Binder9512711
5Eraser517481037
  • 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.

D2fx=ROUNDDOWN(B2*C2,2)
Drop the fractions when converting currency: example table
ABCDE
1InvoiceAmount (EUR)RateConvertedWhole Units
2F-33011,250.4044.873256,109.4456,109
3F-3302380.0044.873217,051.8117,051
4F-33039,725.6544.8732436,421.03436,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

Type this in Nexell

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 table

Bring 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.

Related functions

All math functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free