ROUNDDOWN rounds a number toward zero to a specified number of digits, so it always moves in the direction of zero rather than the nearest value. Use it when you need a guaranteed floor-like cut-off for positive numbers or a ceiling-like cut-off for negative numbers.
=ROUNDDOWN(number, num_digits)What does ROUNDDOWN do?
ROUNDDOWN is one of Excel's Math & trigonometry functions. It takes a number and a digit count and rounds the number toward zero. For positive numbers that means it always goes down, and for negative numbers it always goes up toward zero. Unlike ROUND, it never rounds to the nearest value; it simply chops off the unwanted digits.
That direction matters in real work. If you are calculating a discount, a tax amount, or a time total, rounding to the nearest value can occasionally push a result above a limit. ROUNDDOWN gives you a predictable cut-off: the result is never further from zero than the original number. It is also handy for cleaning up messy decimals in reports without accidentally increasing a figure.
A typical situation is invoicing. Suppose a line item comes to 47.896 and your price list only allows two decimals. =ROUNDDOWN(47.896,2) returns 47.89, so the customer is never overcharged by a rounding step. The same idea works for hours worked, unit counts, and budget caps.
When to use ROUNDDOWN
- Truncating prices or invoice amounts to two decimal places without overcharging.
- Cutting timesheet hours down to the nearest quarter hour for payroll.
- Applying a spending cap where the calculated amount must not exceed the limit.
- Reducing unit counts to whole items when partial units cannot be shipped.
- Standardising survey or sensor readings to one decimal place for reporting.
- Rounding negative adjustments toward zero so deductions are not overstated.
ROUNDDOWN syntax
=ROUNDDOWN(number, num_digits)| Argument | Required? | What to enter |
|---|---|---|
number | Required | The value you want to round toward zero. It can be a number, a cell reference, or a formula result. Example: =ROUNDDOWN(47.896,2) uses 47.896 as the number. |
num_digits | Required | How many digits to keep after the decimal point. Use 0 for a whole number, a positive number for decimal places, or a negative number to round to tens, hundreds and so on. Example: =ROUNDDOWN(1234,-2) returns 1200. |
What it returns: A number rounded toward zero to the requested number of digits. The result is numeric, so it can be used in further calculations.
ROUNDDOWN examples
1 Example 1: Round a price down to two decimals
The goal is to show the basic behaviour of ROUNDDOWN on a single price. The formula =ROUNDDOWN(B2,2) takes the value in B2 and keeps two decimal places, discarding the rest without rounding up. Because the third decimal is 6, a normal ROUND would give 47.90, but ROUNDDOWN gives 47.89. This is the safest choice when you must not overcharge.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Raw Price | |||
| 2 | Widget | 47.896 | 47.89 | ||
| 3 | Gadget | 12.345 | |||
| 4 | Doohickey | 8.999 | |||
| 5 |
2 Example 2: Whole units from a fractional quantity
Here you have order quantities that include fractions because of weight-based picking. The formula =ROUNDDOWN(B2,0) removes all decimals and returns a whole number. For 15.99 it returns 15, not 16, so you never promise more full units than are actually available. The second argument 0 means zero decimal places.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Quantity | |||
| 2 | Bolts | 15.99 | 15 | ||
| 3 | Nuts | 8.01 | |||
| 4 | Washers | 22.5 | |||
| 5 |
3 Example 3: Round to the nearest hundred for a budget
You want to present budget figures in whole hundreds without inflating them. The formula =ROUNDDOWN(B2,-2) uses a negative digit count, which rounds to the left of the decimal point. For 1234 it returns 1200, and for 987 it returns 900. This keeps the reported budget at or below the actual figure.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Department | Budget | |||
| 2 | Marketing | 1234 | 1200 | ||
| 3 | Operations | 987 | |||
| 4 | Research | 4567 | |||
| 5 |
4 Example 4: Timesheet hours to the nearest quarter hour
Payroll often bills in quarter-hour blocks. The formula =ROUNDDOWN(B2*4,0)/4 first multiplies the hours by 4 to count quarter hours, then rounds that count down to a whole number, then divides by 4 to return hours. For 7.62 hours it gives 7.5, and for 8.0 it stays 8.0. This prevents paying for time that was not fully worked.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Employee | Hours | |||
| 2 | Alex | 7.62 | 7.5 | ||
| 3 | Blair | 8 | |||
| 4 | Casey | 6.13 | |||
| 5 |
5 Example 5: Apply a discount but never exceed the cap
A 12.5% discount is calculated on each sale, but the discount must not exceed the stated cap. The formula =MIN(ROUNDDOWN(B2*0.125,2),C2) rounds the discount down to two decimals, then uses MIN to take the smaller of that value and the cap in C2. For a 100.00 sale the discount is 12.50 and the cap is 12.00, so the result is 12.00. For a 50.00 sale the discount is 6.25 and the cap is 12.00, so the result is 6.25.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Sale ID | Sale Amount | Discount Cap | |||
| 2 | S-1001 | 100 | 12 | 12 | ||
| 3 | S-1002 | 50 | 12 | |||
| 4 | S-1003 | 200 | 20 | |||
| 5 |
Common ROUNDDOWN errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The number or num_digits argument is text that Excel cannot convert to a number, such as a word or a cell containing only spaces. | Check the source cells and convert text to numbers, or wrap the value in VALUE. For example, =ROUNDDOWN(VALUE(B2),2). |
| #NAME? | The function name is misspelled, for example ROUNDDOWNN or ROUND_DOWN. | Use the exact spelling ROUNDDOWN and let Excel's formula suggestions complete it. |
| Wrong direction result | Using ROUNDDOWN when you expected nearest-value rounding, or using it on negative numbers without realising it moves toward zero. | Use ROUND for nearest, ROUNDUP to move away from zero, and ROUNDDOWN only when you want toward-zero behaviour. |
| #NUM! | The num_digits argument is extremely large or invalid in a way that Excel cannot process. | Use a sensible digit count, typically between -15 and 15, and avoid cell references that contain errors. |
Tips for using ROUNDDOWN
- Remember the direction: ROUNDDOWN always moves toward zero, so positive numbers get smaller and negative numbers get closer to zero.
- Use negative num_digits to round to tens, hundreds or thousands, for example
=ROUNDDOWN(4567,-3)returns 4000. - Combine ROUNDDOWN with MIN or MAX to enforce caps and floors in one formula.
- For timesheet quarter hours, multiply by 4, round down, then divide by 4 to avoid decimal drift.
- If you need to keep the displayed value and the stored value aligned, apply ROUNDDOWN in the formula rather than relying on cell formatting.
- Test with a value just above a boundary, such as 1.999, to confirm the function cuts rather than rounds.
Frequently asked questions
What is the difference between ROUNDDOWN and ROUND?
ROUND rounds to the nearest value, so 2.6 becomes 3. ROUNDDOWN always moves toward zero, so 2.6 becomes 2. Use ROUNDDOWN when you must not round up.
Does ROUNDDOWN work with negative numbers?
Yes. It rounds toward zero, so -2.6 becomes -2. That is the opposite direction from ROUNDUP, which would give -3.
Can I use ROUNDDOWN to round to the nearest thousand?
Yes. Use a negative num_digits, for example =ROUNDDOWN(4567,-3) returns 4000. The same pattern works for tens and hundreds.
Why does ROUNDDOWN return a different result from what I see in the cell?
Cell formatting can hide decimals. ROUNDDOWN changes the stored value, while formatting only changes the display. Check the formula bar to see the true value.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ROUNDDOWN reference