Excel ROUND DOWN to Whole Number: Formulas and Examples

To round a number down to a whole number in Excel, use ROUNDDOWN with zero decimal places. If the number is in A2, enter =ROUNDDOWN(A2,0) in B2; for example, 7.8 becomes 7. Note that ROUNDDOWN moves toward zero, so a negative value such as -7.8 becomes -7, not -8.

How ROUNDDOWN works

ROUNDDOWN is Excel’s function for reducing a number’s precision in a specified direction. Its syntax is ROUNDDOWN(number,num_digits). The number argument can be a cell reference, a calculation, or a numeric value; num_digits tells Excel how many decimal places to keep. Set num_digits to 0 to return a whole-number result.

The function removes the fractional part without rounding to the nearest integer. That distinction matters: conventional rounding might turn 7.8 into 8, but ROUNDDOWN returns 7. The returned value is still numeric, so you can use it in later calculations, comparisons, sorting, or charting. It does not alter the original cell; it creates a result wherever you enter the formula.

For a column of values in A2:A20, enter the formula in B2 using A2 as the source, then copy it down through B20. Each row will refer to its corresponding source cell. In Microsoft 365 for Windows, you can copy the formula with the fill handle or copy and paste the cell. Excel adjusts the relative reference automatically.

Examples with positive numbers

Assume A2 contains 18.96 and B2 is where you want the whole-number result. Enter =ROUNDDOWN(A2,0) in B2. The result is 18. If A2 contains 18.01, the result is also 18: the amount of the fractional part does not change the direction of the operation.

Here are a few results to make the behavior clear:

With 4.99 in A2, =ROUNDDOWN(A2,0) in B2 returns 4.
With 4.01 in A2, =ROUNDDOWN(A2,0) in B2 returns 4.
With 4 in A2, =ROUNDDOWN(A2,0) in B2 returns 4.

The zero-decimal setting does not mean that Excel changes a value into text or merely hides digits. It calculates a new numeric value with no fractional part. This makes ROUNDDOWN useful when a later formula must use the reduced number, such as counting complete items or assigning a whole-unit quantity.

Negative numbers: ROUNDDOWN versus INT

A common source of confusion is what down means for a negative number. ROUNDDOWN means toward zero, which is the direction of increasing values for negative numbers. If A2 contains -7.8 and B2 is the result cell, =ROUNDDOWN(A2,0) in B2 returns -7. It removes the decimal portion but does not move farther below zero.

Excel’s INT function behaves differently: it rounds down to the next integer, meaning toward negative infinity. If A2 contains -7.8 and B2 is the output cell, =INT(A2) in B2 returns -8. For a positive input such as 7.8, INT returns 7, so the two functions appear identical. Their difference becomes visible with negative fractions.

Choose based on the intended meaning, not just the name of the function:

Use ROUNDDOWN when you mean discard the fractional part by moving toward zero. Examples include reducing a negative adjustment from -7.8 to -7 or keeping only complete units in a value.
Use INT when you mean the greatest integer that is less than or equal to the number. For -7.8, that integer is -8.

For values that may be negative, test the formula on a negative example before applying it to a full worksheet. A result that differs by one is often not an Excel error; it reflects the distinct mathematical rules used by ROUNDDOWN and INT.

Choosing between ROUNDDOWN, TRUNC, and ROUND

TRUNC is another function that removes digits without rounding up. With A2 holding -7.8 and B2 set aside for the result, =TRUNC(A2,0) in B2 returns -7. At zero decimal places, TRUNC and ROUNDDOWN both move toward zero. TRUNC’s second argument is optional; if omitted, Excel truncates to zero decimal places. ROUNDDOWN requires its num_digits argument, so explicitly using 0 makes the whole-number intent easy to see.

ROUND is different because it rounds to the nearest value at the requested precision. With 7.8 in A2 and B2 as the output cell, =ROUND(A2,0) in B2 returns 8. ROUND is suitable when standard nearest-number rounding is wanted, not when every fractional part must be discarded. ROUNDUP, in turn, rounds away from zero; with 7.1 in A2 and B2 as the output, =ROUNDUP(A2,0) returns 8. For negative numbers, away from zero means a more negative result.

In practical terms, the choice is usually one of these:

ROUNDDOWN: remove digits toward zero.
INT: move to the next integer down, including for negative values.
TRUNC: remove digits toward zero, with an optional precision argument.
ROUND: choose the nearest value at the specified precision.
ROUNDUP: move away from zero to the specified precision.

Rounding to tens, hundreds, or decimal places

ROUNDDOWN is not limited to whole numbers. A positive num_digits value keeps decimal places, while a negative value rounds to the left of the decimal point. For example, if A2 contains 1,287 and B2 is the destination, =ROUNDDOWN(A2,-1) in B2 returns 1,280, rounding down to the tens place. With the same layout, =ROUNDDOWN(A2,-2) returns 1,200, reducing the value to the hundreds place.

For decimal precision, if A2 contains 12.987 and B2 is the result cell, =ROUNDDOWN(A2,2) returns 12.98. The 2 means keep two digits after the decimal point. If A2 contains -12.987, that formula returns -12.98 because it moves toward zero. The function is useful for applying a consistent precision rule to measurements or intermediate calculations, but the desired rule should be confirmed before using it for financial or contractual figures.

To make a result a whole number, use 0 rather than leaving the second argument out. This is especially important with ROUNDDOWN, because the second argument is required. A negative argument is not a request to use negative numbers as inputs; it specifies rounding places to the left of the decimal point.

Using the result in a worksheet

For a single calculation, place the source value and result in separate cells. If A2 contains the original number and B2 is the result cell, enter =ROUNDDOWN(A2,0) in B2. Keeping the original value visible makes it easier to audit the calculation and compare the rounded result. If you need the rounded result in another formula, reference B2 rather than retyping the calculation.

For a list, use a consistent layout such as original values in A2:A100 and rounded results in B2:B100. Enter the formula in B2 with A2 as its source, then fill it down. Check the first and last few rows after filling to ensure references have adjusted as expected and that blank or text cells are handled appropriately for your data. If you need to replace the original values with rounded values, first preserve a copy of the source data; overwriting it removes the easy comparison.

Formula separators can depend on regional settings. The examples here use commas, which are the standard argument separators in many Excel installations. If your Excel expects semicolons, the function and arguments are the same, but the separator displayed in the formula bar may differ. Excel for Mac and Excel for the web support the same ROUNDDOWN behavior; menus or interface details can differ, but the formula itself does not require a Windows-only feature.

Formula result versus number formatting

Formatting a cell to show zero decimal places is not the same as rounding down its value. A number format changes how a value appears, while ROUNDDOWN calculates a different numeric result. For example, a cell containing 7.8 may display as 8 when formatted with zero decimal places, even though its underlying value remains 7.8 and a later calculation can still use 7.8.

If the goal is only to make a report easier to read, changing the number format may be enough. If calculations must use the reduced value, use a formula such as ROUNDDOWN. You can also format the formula result for presentation, but formatting is optional: the formula itself has already returned an integer-valued number. Remember that an integer-valued result can still be displayed with decimal places if the result cell’s number format requests them.

Common problems and checks

If a formula returns an unexpected value, first check the sign of the input and the second argument. ROUNDDOWN with 0 removes decimal places toward zero; it does not always produce the same answer as INT. A negative num_digits value rounds to tens, hundreds, or larger place values, so a value such as 1,287 can become 1,280 rather than 1,287.

Check whether the source cell contains a real number or text that looks like a number. Text values can cause a value error or may not behave as intended.
Check the cell reference. A copied formula might point to a blank or a different row if the layout changed.
Check the result cell’s number format. It can make a correct numeric result appear to have extra decimal places or to be rounded differently.
Check the regional formula separator if Excel reports a formula syntax problem; some installations use semicolons instead of commas.
Use a negative test value if your data includes negatives, because ROUNDDOWN and INT differ for negative fractions.

Also be aware that Excel stores many decimal fractions using binary floating-point representation. In ordinary use, ROUNDDOWN behaves as expected, but a calculated value that appears to be an exact decimal may contain a tiny internal difference. If a result is surprising, inspect the source calculation and its displayed precision rather than assuming the function has rounded to the nearest number.

Frequently Asked Questions

What Excel formula rounds down to a whole number?
If the value is in A2 and the result goes in B2, use =ROUNDDOWN(A2,0). It removes the decimal portion toward zero.

Does ROUNDDOWN always round toward negative infinity?
No. ROUNDDOWN moves toward zero. For -7.8, it returns -7. INT moves toward negative infinity and returns -8.

Is TRUNC the same as ROUNDDOWN?
When both are set to zero decimal places, they both remove the fractional part toward zero. TRUNC can omit its digits argument; ROUNDDOWN requires num_digits.

Can I round down to the nearest ten?
Yes. If A2 contains the value and B2 is the output, use =ROUNDDOWN(A2,-1) in B2. The negative one specifies the tens place.

Does formatting a cell to show no decimals round down?
No. Number formatting changes the display, not the stored value or calculations. Use ROUNDDOWN when later formulas must use the reduced number.

Why does my formula show a syntax error?
Check the function spelling, the required second argument, and your regional list separator. In some Excel settings, the separator is a semicolon rather than a comma.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.