To round a value down in Excel, use the ROUNDDOWN function. If A2 contains 12.987 and you want two decimal places, enter =ROUNDDOWN(A2,2); the result is 12.98. You can change the second argument to round to a whole number or to the left of the decimal point. The steps below apply to Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the numbers you want to round down.
- A blank cell for the formula, or a new column if you want to keep the original values unchanged.
- A decision about the precision you need: decimal places, whole numbers, tens, hundreds, or another place value.
You do not need to change a workbook setting or install an add-in. The function calculates a rounded value in a cell; it does not replace the original number unless you later copy and paste the result as a value.
Step-by-Step
- Choose where the result should go. If your source values are in column A, put the first result in B2, beside the first value. Keeping results in a separate column makes it easier to compare rounded numbers with the original data and revise the precision later. If you only need a one-off calculation, you can enter the formula in any empty cell.
- Decide what “down” means for your task.
ROUNDDOWNalways moves toward zero, rather than to the nearest value. For a positive number such as 12.987, that means a smaller result. For a negative number such as -12.987, moving toward zero produces -12.98, which is actually greater than the starting value. If you mean the mathematical direction toward negative infinity, use a different approach, explained under Common Mistakes. - Enter the ROUNDDOWN formula. With 12.987 in A2 and the result cell in B2, enter
=ROUNDDOWN(A2,2). Press Enter. Excel returns 12.98 because the second argument, 2, keeps two digits after the decimal point and discards the rest without rounding the retained digits upward. In Excel for Windows, you can type directly into B2 or select B2 and enter the formula in the formula bar. - Set the number of digits you want to keep. The second argument controls the position at which Excel truncates the value. With 348.75 in A2 and the answer in B2,
=ROUNDDOWN(A2,0)returns 348, removing the decimal part. With 348.75 in A2 and the answer in B2,=ROUNDDOWN(A2,-1)returns 340, rounding down to the nearest ten. With 348.75 in A2 and the answer in B2,=ROUNDDOWN(A2,-2)returns 300, rounding down to the nearest hundred. - Check the result against the source value. Confirm both the displayed result and the intended precision. For example, a result of 12.98 is correct when keeping two decimal places from 12.987. A result of 13.0 would indicate normal rounding or a changed value, not the intended ROUNDDOWN result. Remember that cell formatting can hide digits; select the result cell and inspect the formula bar if the displayed number seems unexpected.
- Apply the formula to other rows if needed. With source values in A2:A20 and the first result formula in B2, use
=ROUNDDOWN(A2,2)in B2, then drag the fill handle at the lower-right corner of B2 down through B20. Excel adjusts the reference for each row, so B3 uses A3, B4 uses A4, and so on. You can also copy B2, select B3:B20, and paste. Check a few results, including any negative or unusually large values, before relying on the entire column. - Keep the result or replace the source only if appropriate. The formula result updates when its referenced value changes. If you need a fixed set of rounded values, copy the result cells, then use Home > Paste > Paste Values to replace formulas with their current results. This removes the connection to the source cells, so do it only when you no longer need the results to recalculate.
The function follows this pattern: =ROUNDDOWN(number,num_digits). For a cell reference, number is the value or cell to process; num_digits is the number of decimal places to retain. Positive values retain decimal places, zero keeps no decimal places, and negative values round to positions left of the decimal point. The formula examples here use commas as argument separators. Depending on your regional settings, your copy of Excel may expect semicolons instead; if Excel flags the comma as a problem, use the separator configured for your system.
Common Mistakes
- Confusing ROUNDDOWN with rounding to the nearest value.
ROUNDDOWNdoes not look at the discarded digits to decide whether to increase the retained digits. For instance, a positive value ending in .99 still has its extra decimal digits removed rather than causing the retained part to round up. Use Excel’sROUNDfunction when you want conventional nearest-number rounding instead. - Expecting “down” to mean toward negative infinity. ROUNDDOWN moves toward zero for both positive and negative values. With -12.987 in A2 and the result in B2,
=ROUNDDOWN(A2,0)returns -12. If your rule requires the next lower whole number on the number line, that result is not low enough. With -12.987 in A2 and the result in B2,=INT(A2)returns -13, because INT rounds down to the next integer. Choose based on the rule you need, not just the function name. - Using the wrong sign for num_digits. A positive second argument means decimal places; zero means an integer; a negative argument means tens, hundreds, or larger place values. Entering 2 when you meant the nearest hundred will keep two decimal places instead. For a hundreds position, use -2.
- Changing the display format instead of the value. The Home tab’s decimal-place controls can make a number look like it has fewer decimals without changing its stored value. That can affect later calculations. Use ROUNDDOWN when the underlying calculation must use the truncated value, and use cell formatting only when you want to change how a number is displayed.
- Overwriting data before checking the calculation. A formula in a new column is easier to audit than replacing source values immediately. Check sample results and confirm the rounding rule before using Paste Values or deleting the originals.
Tips
- Use a reference rather than typing a constant into every formula. Referencing a source cell makes the calculation easier to fill down and means a corrected source value flows through automatically. It also makes the workbook easier for someone else to review.
- Make the precision easy to change. If you expect to change the number of decimal places, enter that setting in a separate cell. With the value in A2, the desired digit count in C1, and the result in B2, use
=ROUNDDOWN(A2,$C$1). If C1 contains 2 and A2 contains 12.987, B2 returns 12.98. The dollar signs keep the setting reference fixed when you copy the formula down. - Use formatting to make the output readable. After calculating the value, select the result cells and use Home > Number to choose a suitable number format. The format affects what you see, while the formula determines the value used in calculations. For example, a formula can return 12.9 while a format displays 12.90; the extra zero is display-only.
- Test boundary and negative values. If your list includes values just above or below zero, very large numbers, or negative amounts, check a few by hand. These are the cases most likely to expose a misunderstanding about direction or the chosen place value.
- Keep source data and calculation results distinct. Clear headings such as Original value and Rounded down help prevent someone from treating the result as the source. This is especially useful in shared workbooks, reports, and exported data.
Troubleshooting
Excel displays an error after you enter the formula. Check that the function name is spelled ROUNDDOWN, the opening and closing parentheses are present, and the two arguments are separated correctly. The examples use commas. Regional settings may require semicolons, so match the separator Excel accepts on your computer. Also make sure the referenced cell exists and contains a number or a value Excel can interpret as numeric.
The result looks rounded up. Inspect the full value in the formula bar and confirm you used ROUNDDOWN rather than ROUND or a display-only number format. A negative result can also look surprising: moving toward zero makes a negative value less negative. If the requirement is to always move to a lower number on the number line, use INT for whole numbers, or clarify the needed place-value rule before choosing another function.
The cell shows the formula instead of an answer. The cell may be formatted as Text, or Excel may be treating the entry as text. Change the cell format to General using Home > Number Format, then re-enter the formula. Check that the entry begins with an equals sign and that Show Formulas is not turned on. On Windows, Ctrl+` toggles Show Formulas; on Mac, the equivalent shortcut can vary with keyboard layout, so use the Formulas tab and select Show Formulas if needed.
The result has fewer or more visible decimals than expected. Select the cell and look at the formula bar to distinguish the actual value from its display. Adjust the number format from Home > Number, or use the increase/decrease decimal controls to show more or fewer digits. Do not assume that hiding decimal places changes the value used in downstream formulas.
Filling down repeats the same result or refers to the wrong cell. Check the formula in a lower row. A relative reference such as A2 should become A3 in the next row. If the formula uses dollar signs around the row reference, such as $A$2, it will keep pointing to the same cell. Use fixed references only for settings you want to remain constant, such as the digit count in C1.
Frequently Asked Questions
What is the Excel formula to round down to two decimal places?
Use ROUNDDOWN with 2 as the digit argument. If A2 contains 12.987 and you want the result in B2, enter =ROUNDDOWN(A2,2); the result is 12.98. The function removes extra decimal digits rather than rounding the second decimal place to the nearest value.
How do I round down to a whole number?
Set the digit argument to zero. With 348.75 in A2 and the result in B2, =ROUNDDOWN(A2,0) returns 348. For a negative number, this still means toward zero: -348.75 becomes -348, not -349.
How do I round down to the nearest ten or hundred?
Use a negative digit argument: -1 for tens, -2 for hundreds, and -3 for thousands. With 348.75 in A2 and the answer in B2, =ROUNDDOWN(A2,-1) returns 340; with the same cell layout, =ROUNDDOWN(A2,-2) returns 300.
What is the difference between ROUNDDOWN and INT?
ROUNDDOWN truncates toward zero at the precision you specify. INT returns the greatest integer less than or equal to the input, so its behavior differs for negative decimals. For example, ROUNDDOWN applied to -12.987 at zero decimal places gives -12, while INT gives -13.
Can I round down without changing the original number?
Yes. Put the formula in another cell or column and leave the source value in place. The formula result recalculates if the referenced value changes. If you later need a fixed result, copy the formula cells and paste values into a destination, keeping the original data if you may need it for comparison.
Related
- How to Paste in Excel and Keep Formatting
- How to Paste in Excel Only Visible Cells Without Hidden Rows
- Paste in a Filtered List in Excel Without Hidden Rows
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Text Unique Values: Extract, Count, and CompareYes. In Excel for Microsoft 365, use UNIQUE to return a list of distinct text values from a…
- Excel Split Cells With Regex: Formulas and MethodsYes—Excel for Microsoft 365 can split text using a regular expression by replacing regex-matched separators with a marker…
- Using ROUNDUP in Excel: 10 Practical Formula ExamplesTo round a number up in Excel, use ROUNDUP with the number and the number of digits to…
- Extract the First Word in Excel With a FormulaTo extract the first word from text in Excel, put the source text in A2 and enter =LEFT(TRIM(A2),FIND("…
- How to Add Footnotes in a Word Table the Right WayTo add a true footnote to a Word table, click in the table cell where the reference belongs,…
- Excel SUMIFS Month and Year: Formula GuideTo sum values by month and year in Excel, use the SUMIFS function with two criteria: one that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.