Round Down in Excel: Formulas for Specific Decimal Places

To round a value down to a chosen number of decimal places in Excel, use the ROUNDDOWN function. For example, if A2 contains 3.14159, enter =ROUNDDOWN(A2,1) in another cell to return 3.1; change the final argument to choose a different decimal place.

What ROUNDDOWN Does

ROUNDDOWN reduces a number’s precision without rounding it up. Its two arguments are the value to change and the number of digits to keep. The result remains a number, so you can use it in calculations, comparisons, and charts. The function changes the calculated value, unlike a number format that only changes how a value looks.

In a worksheet with the value to process in A2, this formula keeps one digit after the decimal point and returns 3.1 when A2 is 3.14159: =ROUNDDOWN(A2,1). The result is not 3.2, because ROUNDDOWN does not look at the next digit to decide whether to increase the retained digit. It simply discards the unwanted precision in the direction toward zero.

The argument can be positive, zero, or negative. A positive number specifies digits to the right of the decimal point. Zero rounds down to a whole number. A negative number specifies digits to the left of the decimal point, such as tens or hundreds. This flexibility is useful for prices, measurements, counts, and other values that need a consistent precision.

Choose the Decimal Place

The second argument determines where Excel stops retaining digits. In the following examples, the value being processed is in A2 and each formula is entered in another cell:

For one decimal place, such as tenths, use =ROUNDDOWN(A2,1). With 8.764 in A2, the result is 8.7.
For two decimal places, such as hundredths, use =ROUNDDOWN(A2,2). With 8.764 in A2, the result is 8.76.
For three decimal places, such as thousandths, use =ROUNDDOWN(A2,3). With 8.7649 in A2, the result is 8.764.
For a whole number, use =ROUNDDOWN(A2,0). With 8.764 in A2, the result is 8.
To drop to the nearest ten, use =ROUNDDOWN(A2,-1). With 876.4 in A2, the result is 870.

These examples assume the listed input is in A2 and the formula is entered in a different cell. A positive digit count does not mean “round up”; it only identifies the decimal position to retain. For instance, 2 means two places after the decimal point, not two significant digits.

Enter the Formula and Fill It Down

To apply the same rule to a column of values in Excel for Microsoft 365 on Windows:

Put the first number in a cell such as A2.
Select the result cell next to it, such as B2, and type the ROUNDDOWN formula. If A2 contains 6.289, entering =ROUNDDOWN(A2,2) in B2 returns 6.28.
Press Enter to calculate the result.
To process more rows, select B2 and drag its fill handle down the column, or double-click the fill handle when adjacent rows contain data.

When Excel copies the formula down, the relative reference changes: the formula beside A3 uses A3, and the formula beside A4 uses A4. If you need to reuse the same number of decimal places in many formulas, put that setting in a cell. For example, with source values in A2:A20 and a digit setting in C1, enter =ROUNDDOWN(A2,$C$1) in B2 and fill down. If C1 contains 2, the formula keeps two decimal places for every row. The dollar signs keep the reference to C1 fixed while the A2 reference adjusts.

ROUNDDOWN and Negative Numbers

A common source of surprise is the meaning of “down.” Excel’s ROUNDDOWN function moves toward zero, not always toward the smaller number on the number line. For positive numbers, those directions look the same. For negative numbers, they differ: moving toward zero makes the result less negative.

With -3.141 in A2, and the result placed in another cell, =ROUNDDOWN(A2,1) returns -3.1. It does not return -3.2. The first result is closer to zero; the second is the next lower tenth on the number line. This behavior matters for negative measurements, account adjustments, and any calculation that can produce a negative result.

If by “round down” you mean always move to the next lower multiple, including for negative numbers, use FLOOR.MATH instead. With -3.141 in A2, this formula returns -3.2: =FLOOR.MATH(A2,0.1). For a positive number such as 3.141, the same significance of 0.1 returns 3.1. FLOOR.MATH is appropriate when the rule is about lower multiples; ROUNDDOWN is appropriate when the rule is to remove decimal places toward zero.

Round Down to a Multiple, Not a Decimal Place

Decimal places and multiples are related but not interchangeable. Keeping two decimal places means retaining hundredths, so a value such as 7.386 becomes 7.38 with ROUNDDOWN. Rounding down to the nearest 0.05 means choosing a value from a different set of steps: 0.00, 0.05, 0.10, and so on. The answer for 7.386 is then 7.35, not 7.38.

With a positive value in A2, enter =FLOOR.MATH(A2,0.05) in another cell to round down to a multiple of five cents. For 7.386, the result is 7.35. Use the multiple that matches the real rule, such as 0.25 for quarter-unit increments or 5 for steps of five whole units. Do not use this method merely because a value should show a certain number of decimal places.

For negative values, FLOOR.MATH follows a lower-multiple rule by default, which can produce a more negative result. If your requirement is instead to remove digits toward zero, use ROUNDDOWN. Testing one positive and one negative example against the intended rule is a practical way to confirm that you chose the right function.

Compare ROUNDDOWN with ROUND and Formatting

ROUNDDOWN differs from ROUND, which rounds to the nearest specified decimal place. With 4.768 in A2, =ROUND(A2,2) returns 4.77, while =ROUNDDOWN(A2,2) returns 4.76. Use ROUND when the result should be the nearest value, and use ROUNDDOWN when the rule specifically forbids increasing the retained value.

Formatting is different from either formula. To show fewer decimals without changing the stored number, select the cells and choose Home > Number > Decrease Decimal. You can also open Format Cells with Ctrl+1 on Windows, choose the Number category, and set Decimal places. On a Mac, Command+1 opens Format Cells; the ribbon’s number controls may be arranged differently from Windows. Formatting is useful when the goal is presentation, but calculations still use the underlying values.

For example, a cell containing 4.768 may display as 4.77 when formatted to two decimal places, yet another formula can still calculate with 4.768. If you need later calculations to use 4.76, put a ROUNDDOWN formula in a result column and base those calculations on that result. Avoid changing a whole worksheet’s precision settings just to display fewer digits; that setting can affect stored values and may discard information.

Common Problems and Checks

The result looks rounded up. Check whether you are looking at the formula result or only its formatting. A formatted value can show fewer digits than the underlying value.
A negative result is not as low as expected. ROUNDDOWN moves toward zero. Use FLOOR.MATH when you need the lower multiple on the number line.
The formula returns an error. Check that the referenced cell contains a number rather than text, and that the digit argument is numeric. In some regional Excel settings, the list separator is a semicolon rather than a comma; use the separator Excel expects in that installation.
The formula changes the wrong decimal place. Remember that 1 means tenths, 2 means hundredths, and 0 means a whole number. Negative digit arguments act to the left of the decimal point.
A total differs from expectations. Rounding each row before adding can produce a different total from adding full-precision values and rounding only the final sum. Decide whether the rule applies to each item or to the aggregate, then place the formulas accordingly.

For instance, if the source numbers are in A2:A3 and each row must be truncated to one decimal place before a total is calculated, put =ROUNDDOWN(A2,1) in B2, copy it to B3, and total B2:B3. With 1.29 and 1.29 in A2:A3, the rounded-down row values are 1.2 and 1.2, so the total is 2.4. Adding the original values first gives 2.58; rounding that total down to one decimal place gives 2.5. Neither approach is universally correct—the intended calculation rule determines which one to use.

Frequently Asked Questions

How do I round down to two decimal places in Excel?
With the number in A2 and the formula in another cell, enter =ROUNDDOWN(A2,2). For 12.987, the result is 12.98.

What formula rounds down to one decimal place?
If A2 contains the value, use =ROUNDDOWN(A2,1) in another cell. For 5.89, it returns 5.8.

Does ROUNDDOWN work on negative numbers?
Yes. It rounds toward zero, so -5.89 rounded to one decimal place becomes -5.8. Use FLOOR.MATH if you instead need the next lower tenth, -5.9.

How can I remove decimals without changing the original cell?
Enter a ROUNDDOWN formula in a separate cell and refer to the original value. If you only need fewer digits on screen, use the Decrease Decimal control; formatting does not change the stored value.

Can I round down to the nearest five cents?
Yes. With a positive value in A2, enter =FLOOR.MATH(A2,0.05) in another cell. A value of 7.386 returns 7.35, which is a multiple of 0.05 rather than simply a number with two decimal places.

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.