Excel often requires precise number control, especially when you need to reduce numbers without accidentally rounding up. That’s where the ROUNDDOWN function becomes extremely useful.
Unlike the ROUND function, which rounds normally, or ROUNDUP, which always rounds higher, ROUNDDOWN always rounds numbers downward toward zero—even if the decimal would normally round up.
This makes ROUNDDOWN especially helpful when working with budgets, pricing limits, time tracking, and inventory counts, where exceeding a number is not allowed.
In this guide, you’ll learn:
- What the ROUNDDOWN function does
- How to write a ROUNDDOWN formula correctly
- How to round numbers down to decimal places
- How to round numbers down to whole numbers
- How to round numbers down to tens, hundreds, or thousands
- Common mistakes to avoid when using ROUNDDOWN
What Does the ROUNDDOWN Function Do?
The ROUNDDOWN function rounds a number down toward zero, regardless of the value of the digits being removed.
For example:
- 8.79 rounded down to 1 decimal place becomes 8.7
- 8.79 rounded down to 0 decimals becomes 8
- 8.79 rounded down to the nearest ten becomes 0
Unlike regular rounding, ROUNDDOWN never increases a number.
That makes it useful anytime you need to stay under a specific value.
ROUNDDOWN Function Syntax
The syntax for the ROUNDDOWN function is:
=ROUNDDOWN(number, num_digits)
Argument Breakdown
number
The value you want to round down.
num_digits
Controls how many digits remain after rounding.
- Positive number → rounds decimals
- Zero → rounds to whole number
- Negative number → rounds to tens, hundreds, etc.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> ROUNDDOWN Function Data
Rounding Down to Two Decimal Places
Let’s start with a simple example where we round numbers down to two decimal places.
In cell B2, enter:
=ROUNDDOWN(A2,2)
Press Enter
Copy the formula down through B6
You will now see each number rounded down to two decimal places.
Rounding Down to a Whole Number
To round down to the nearest whole number, use 0 as num_digits.
Example:
=ROUNDDOWN(A2,0)
This removes all decimal places and rounds the number down toward zero.
Example results:
- 8.987 → 8
- 15.239 → 15
- 22.876 → 2210
Rounding Down to Tens, Hundreds, or Thousands
You can round numbers down to larger place values using negative numbers.
| num_digits | What Happens |
|---|---|
| -1 | Rounds down to nearest ten |
| -2 | Rounds down to nearest hundred |
| -3 | Rounds down to nearest thousand |
Rounding Down to the Nearest Ten
=ROUNDDOWN(A2,-1)
Example results:
- 87 → 80
- 143 → 140
- 999 → 990
ROUNDDOWN vs ROUND vs ROUNDUP
Understanding the difference between these three functions is important.
| Function | Behavior |
|---|---|
| ROUND | Rounds normally |
| ROUNDUP | Always rounds up |
| ROUNDDOWN | Always rounds down |
Example Comparison:
| Original | ROUND | ROUNDUP | ROUNDDOWN |
|---|---|---|---|
| 8.76 | 8.8 | 8.8 | 8.7 |
Common Mistakes to Avoid
Even though ROUNDDOWN is simple, users often make small mistakes.
Using the Wrong num_digits Value
Remember:
- Positive → decimals
- Zero → whole number
- Negative → tens/hundreds
Using the wrong sign can produce unexpected results.
Forgetting That ROUNDDOWN Always Moves Toward Zero
This is especially important with negative numbers.
Example:
=ROUNDDOWN(-8.76,1)
Result: -8.7
Not -8.8, because it moves toward zero.
When Should You Use ROUNDDOWN?
Use ROUNDDOWN when exceeding a value could cause problems.
Common examples include:
- Budget calculations
- Inventory limits
- Labor hour tracking
- Pricing calculations
- Tax estimates
Anywhere staying under a limit matters, ROUNDDOWN is useful.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> ROUNDDOWN Function Data
