ROUNDDOWN Function in Excel
Rounds a number toward zero, dropping the fractional part regardless of size. The function behind budget-safe item counts, tax-deductible truncation, and "how many can we actually afford" math. When over-counting costs money, this is your function.
The "Always Toward Zero" Principle
Every rounding function has one rule. ROUNDDOWN's rule is the mirror of ROUNDUP: always move toward zero. Preserves the sign, drops the fraction.
Positive numbers — go DOWN
Negative numbers — go UP
Quick Answer
ROUNDDOWN rounds a number toward zero to the number of decimal places you specify. It always truncates the fraction, regardless of value. No tie-breaking, no direction ambiguity.
Example: =ROUNDDOWN(24.99, 0) returns 24. =ROUNDDOWN(-24.99, 0) returns -24 (toward zero, so up). =ROUNDDOWN(1245.87, -2) returns 1200 — negative digits round to left of decimal.
💰 Rounding Family Practice Workbook
All 5 ROUNDDOWN examples plus ROUND and ROUNDUP patterns on 18 realistic invoice line items.
Syntax
ROUNDDOWN takes exactly two arguments — identical shape to ROUND and ROUNDUP.
| Argument | Type | Description |
|---|---|---|
| number | Required | The number, cell reference, or formula result to round toward zero. |
| num_digits | Required | How many decimal places to keep. 2 = cents. 0 = whole number. -1 = tens. -2 = hundreds. Range: about -15 to +15. |
Direction rule: ROUNDDOWN always moves toward zero. There is no tie-breaking — any non-zero fractional part is truncated in the direction of zero.
5 Worked Examples
Truncate cents for safe-quantity reporting
When over-reporting is worse than under-reporting — inventory counts, guaranteed payouts, conservative revenue recognition — ROUNDDOWN gives you the "at least this much" number.
| Value | Formula | Truncated | Cents Dropped |
|---|---|---|---|
| $24.99 | =ROUNDDOWN(A2, 0) | $24 | $0.99 |
| $149.99 | =ROUNDDOWN(A3, 0) | $149 | $0.99 |
| $1,245.87 | =ROUNDDOWN(A4, 0) | $1,245 | $0.87 |
| $89.01 | =ROUNDDOWN(A5, 0) | $89 | $0.01 |
| $3.999 | =ROUNDDOWN(A6, 0) | $3 | $0.999 |
Notice row 4: $89.01 → $89. Even one cent over triggers no rounding-up mercy — that's the point. If you promised "at least $89," you deliver $89.
Budget math — how many full items can you actually afford?
With $100 and $24.99 items, you can afford exactly 4 (not 4.001). You can't buy a fractional item. ROUNDDOWN gives you the safe integer count that respects your budget.
| Budget | Item Price | Raw Division | Items You Can Buy |
|---|---|---|---|
| $100 | $24.99 | 4.0016 | 4 |
| $500 | $149.99 | 3.3336 | 3 |
| $250 | $47.833 | 5.2266 | 5 |
| $50 | $18.475 | 2.7063 | 2 |
| $1,000 | $249.995 | 4.0001 | 4 |
Row 5 is the killer: $1,000 ÷ $249.995 = 4.0001. Looks like 4. Is 4. But ROUND would give you 4 too — through luck, not logic. ROUNDDOWN gives you 4 reliably for any budget-affordability question.
Positive vs negative sign behavior
ROUNDDOWN moves toward zero in both directions. Positive rounds smaller; negative rounds larger (closer to zero on the number line). Fraction is always discarded.
| Input | Formula | Result | Direction |
|---|---|---|---|
| 1.1 | =ROUNDDOWN(1.1, 0) | 1 | positive → down (toward 0) |
| 1.9 | =ROUNDDOWN(1.9, 0) | 1 | positive → down (toward 0) |
| -1.1 | =ROUNDDOWN(-1.1, 0) | -1 | negative → UP (toward 0) |
| -1.9 | =ROUNDDOWN(-1.9, 0) | -1 | negative → UP (toward 0) |
| 0 | =ROUNDDOWN(0, 0) | 0 | zero stays zero |
"ROUNDDOWN" of a negative doesn't mean "toward more negative" — it means "toward zero." If you want true floor (toward negative infinity), use INT or FLOOR.MATH instead. See the confused-trio table below.
The confused trio — ROUNDDOWN vs INT vs TRUNC on real data
For POSITIVE numbers, all three agree. For NEGATIVE numbers they split: INT goes to the more-negative integer (true floor); ROUNDDOWN and TRUNC go toward zero (truncation). This trip-up is the single most confusing pattern in Excel's rounding functions.
| Input | =INT(x) | =TRUNC(x) | =ROUNDDOWN(x, 0) |
|---|---|---|---|
| 4.7 | 4 | 4 | 4 |
| 4.999 | 4 | 4 | 4 |
| 0.5 | 0 | 0 | 0 |
| -0.5 | -1 | 0 | 0 |
| -4.7 | -5 | -4 | -4 |
| -4.999 | -5 | -4 | -4 |
Bottom three rows are the divergence zone. If your data is guaranteed non-negative (revenue, quantities, counts), all three are interchangeable. If negatives are possible (P&L, temperature, coordinates), pick deliberately: INT for true floor, ROUNDDOWN/TRUNC for truncation-toward-zero.
Tax-deductible truncation (IRS-safe conservative reporting)
US IRS instructions often say "you may round to whole dollars — but round consistently, and truncation is always safe." ROUNDDOWN prevents claiming a fractional cent more than you actually paid, which is the audit-safe approach.
| Invoice | Total (raw) | ROUND (mid) | ROUNDDOWN (safe) |
|---|---|---|---|
| INV-1001 | $80.405325 | $80 | $80 |
| INV-1002 | $138.7010625 | $139 | $138 |
| INV-1003 | $162.364175 | $162 | $162 |
| INV-1004 | $536.239275 | $536 | $536 |
| INV-1005 | $318.6175 | $319 | $318 |
Row 2 and 5 show where ROUND over-claims by a dollar each. In deduction math, the auditor's principle is simple: if you can't prove the extra dollar, you can't claim it. ROUNDDOWN guarantees you never over-claim. Small individually, meaningful across a full tax year.
Interactive Playground
Input Values
A3 → -24.99
A4 → 100 ÷ 24.99 budget
A5 → 1245.87
A6 → -4.7 (compare all 3)
Formula & Result
The Rounding Family
Three functions for three different needs. Pick by what "round" means for your use case.
⚠ The Confused Trio — ROUNDDOWN vs INT vs TRUNC
Three Excel functions all discard the fractional part. On positive numbers they agree. On negatives they split into two camps, and this is where 90% of "why is my formula returning -5 instead of -4?" questions come from.
| Input | =INT(x) | =TRUNC(x) | =ROUNDDOWN(x, 0) |
|---|---|---|---|
| 4.7 | 4 | 4 | 4 |
| 4.001 | 4 | 4 | 4 |
| 4.999 | 4 | 4 | 4 |
| 0 | 0 | 0 | 0 |
| -0.5 | -1 | 0 | 0 |
| -4.001 | -5 | -4 | -4 |
| -4.7 | -5 | -4 | -4 |
| -4.999 | -5 | -4 | -4 |
Rules of thumb:
• INT — use for mathematical floor. Always toward −∞. Good for "how many complete cycles fit below this value."
• TRUNC — use for "chop the fraction." Always toward zero. One-argument variant of ROUNDDOWN.
• ROUNDDOWN — use when you need decimal-place control. Same behavior as TRUNC but with an explicit num_digits argument.
Choosing: if all your data is non-negative, pick whichever reads clearest in your formula. If negatives are possible, the direction difference is real — decide before writing the formula, not after.
ROUNDDOWN vs FLOOR — Different Axes, Different Tools
Both round downward. ROUNDDOWN works on decimal places; FLOOR works on multiples. Different jobs.
| Aspect | ROUNDDOWN | FLOOR / FLOOR.MATH |
|---|---|---|
| Rounds by | Decimal place (2, 0, -1, ...) | Multiple of significance (5, 25, 100, "0:15") |
| Syntax | ROUNDDOWN(number, num_digits) |
FLOOR(number, significance) |
| Direction on positives | Toward zero (down) | Toward zero (down) |
| Direction on negatives | Toward zero (less negative) | Away from zero (more negative) — FLOOR.MATH |
| Round 47.83 down to nearest $5 | =ROUNDDOWN(47.83/5, 0)*5 → 45 |
=FLOOR(47.83, 5) → 45 |
| Round time down to 15 min | Complex (multiply / divide dance) | =FLOOR(A2, "0:15") — cleaner |
| Best for | Decimal precision (cents, whole units, truncation) | Rounding down to a multiple ($5 tiers, 15-min slots, 100ml) |
Rule of thumb: if you'd describe it as "round down to the nearest N decimal places" → ROUNDDOWN. If you'd describe it as "round down to the nearest multiple of X" → FLOOR.MATH.
Common Errors
| Symptom | Cause | Fix |
|---|---|---|
| Result higher than expected on negatives | ROUNDDOWN of a negative moves toward zero (less negative). Surprises people who expect "down = toward negative infinity." | Correct behavior. If you want true floor (toward −∞), use =INT(A2) or =FLOOR.MATH(A2, 1, 1). |
| -4 instead of -5 for -4.7 | You expected INT behavior but used ROUNDDOWN. ROUNDDOWN truncates toward zero; INT floors toward −∞. | Swap ROUNDDOWN for INT if you need true floor. Or accept: for coordinate/temperature math, INT is usually correct; for "how many complete units fit in this quantity," ROUNDDOWN is usually correct. |
| Budget count is 0 when you have money | =ROUNDDOWN($5 / $6.99, 0) returns 0 correctly — you can't buy a full item with less than its price. |
Working as intended. If you want to detect this case, wrap with IF: =IF(ROUNDDOWN(budget/price,0)=0, "Not enough", ROUNDDOWN(budget/price,0) & " items"). |
| #VALUE! | Argument is text or an error value. | Ensure numeric input. Wrap with VALUE() for numeric text, or with IFERROR() for defensive formulas. |
| #NUM! | num_digits outside supported range (roughly -15 to +15). | Clamp num_digits. For most business use, values -5 to +5 cover everything you'll need. |
| Sum of ROUNDDOWNs differs from ROUNDDOWN of sum | Rounding at row level vs total level gives different results — this is arithmetic, not a bug. | Decide first: do you truncate per row or per total? Then apply ROUNDDOWN at that level, consistently. For per-item tax deductions, per-row is standard. |
💰 Practice on Real Business Data
Every ROUNDDOWN pattern — budget math, tax truncation, INT/TRUNC comparison — on 18 real invoice rows plus dedicated demo sheets.
Related Functions
Compatibility
| Platform | Supported | Version | Notes |
|---|---|---|---|
| Excel for Windows | ✓ | 1.0+ (1985) | All versions |
| Excel for Mac | ✓ | 1.0+ | All versions |
| Microsoft 365 | ✓ | Current | Full support |
| Excel Online | ✓ | Current | Full support |
| Excel Mobile (iOS/Android) | ✓ | Current | Full support |
| Google Sheets | ✓ | All | Identical behavior |
| LibreOffice Calc | ✓ | All | Identical behavior |
How to Use ROUNDDOWN — Step by Step
- Click an empty cell where the truncated value should appear.
- Type
=ROUNDDOWN(— Excel auto-suggests as soon as you type "ROUND". - Reference the source or type a value, then add a comma and the number of decimal places:
=ROUNDDOWN(A2, 0)for whole numbers. - Close with
)and press Enter. - For budget math, use:
=ROUNDDOWN(budget / item_price, 0). You get the exact integer number of items you can afford — no fractional pretending. - For tax-deductible truncation, use:
=ROUNDDOWN(deductible_amount, 0). Audit-safe — you never claim a fractional cent you can't prove. - If you need true floor on negatives (toward −∞), don't use ROUNDDOWN — use
=INT(A2)or=FLOOR.MATH(A2, 1, 1)instead. See the confused-trio table above.
Explore More Functions
💰 One More Time — Grab the Workbook
Every ROUNDDOWN pattern plus ROUND and ROUNDUP, on 18 real invoice rows. Free, one file, six sheets.
Frequently Asked Questions
Does ROUNDDOWN round toward negative infinity?
No. ROUNDDOWN rounds toward zero. For positive numbers that's the same as "down," but for negatives it means going less negative (closer to zero).
If you need true floor toward −∞, use =INT(A2) or =FLOOR.MATH(A2, 1, 1). This distinction only matters if your data contains negatives.
What's the difference between ROUNDDOWN and TRUNC?
Almost none. Both truncate toward zero. TRUNC takes one required argument (optional second for decimal places, defaults to 0). ROUNDDOWN requires two arguments always.
For whole-number truncation, =TRUNC(A2) is shorter than =ROUNDDOWN(A2, 0). For decimal-place control, they're equivalent: =TRUNC(A2, 2) equals =ROUNDDOWN(A2, 2). Pick whichever reads clearest in your formula.
What's the difference between ROUNDDOWN and INT?
For positive numbers they're identical (both discard the fraction). For negative numbers they split: INT floors toward negative infinity; ROUNDDOWN truncates toward zero.
Example: =INT(-4.7) = -5 (further from zero); =ROUNDDOWN(-4.7, 0) = -4 (toward zero). If your data is guaranteed non-negative, either works. Otherwise choose deliberately — see the confused-trio table above.
How do I calculate how many items I can afford with a budget?
Standard formula: =ROUNDDOWN(budget / item_price, 0). Returns the exact integer count you can afford. Never over-counts.
To handle the "not enough for even one item" case: =IF(ROUNDDOWN(budget/price, 0) = 0, "Not enough", ROUNDDOWN(budget/price, 0) & " items"). Great for shopping cart limits, subscription tier calculations, or bulk order optimizers.
Can ROUNDDOWN round to nearest 10 or 100?
Yes — use negative num_digits. =ROUNDDOWN(A2, -1) rounds down to nearest 10. =ROUNDDOWN(A2, -2) rounds down to nearest 100. So 12345.67 → 12340 → 12300 → 12000 as you go from -1 to -3.
Useful for "salary band lower bound" calculations, floor-tier pricing ("no less than $100 discount"), or conservative capacity reporting ("we can serve at least 200 users").
Is ROUNDDOWN(4.999, 0) really 4 and not 5?
Yes, really 4. ROUNDDOWN has no tie-breaking rule and no "close enough to next integer" logic. Any non-zero fractional part is truncated. 4.999 is not 5 — it's 4.999. ROUNDDOWN discards the .999.
This is intentional: if you want 5 back, you want ROUND (which uses half-away-from-zero, so 4.5 and above → 5). ROUNDDOWN is for cases where "at least" matters more than "closest to."
Why is my sum of ROUNDDOWNs less than the total?
Expected. Each row loses its fractional part; those pennies don't reappear anywhere. Over many rows the "lost" cents can add up to visible dollars.
If you want the sum to match the raw total, don't round each row — round the total instead. If you want penny-perfect rows AND matching total, use ROUND (not ROUNDDOWN) and accept that some rows drift half a cent up.
Can I use ROUNDDOWN to truncate to millions or billions?
Yes. =ROUNDDOWN(A2, -6) truncates to nearest million (floor toward zero). =ROUNDDOWN(A2, -9) to nearest billion. For a financial dashboard showing "$47M+", the formula =ROUNDDOWN(revenue, -6)/1000000 & "M+" gives you a conservative headline number.
Does ROUNDDOWN work on dates and times?
Yes — Excel stores dates and times as numbers. =ROUNDDOWN(NOW(), 0) gives you midnight of today (drops the time portion). Same result as =INT(TODAY()) for date-only extraction.
For time-slot truncation (round to prior 15-min slot), FLOOR is cleaner: =FLOOR(A2, "0:15"). ROUNDDOWN would require fractional-day math: =ROUNDDOWN(A2 * 96, 0) / 96.
Can I use ROUNDDOWN inside a conditional formula?
Yes. Common patterns: =IF(A2 > 100, ROUNDDOWN(A2, 0), A2) only truncates values above 100. Or =IF(ROUNDDOWN(budget/price, 0) = 0, "Insufficient", ROUNDDOWN(budget/price, 0)) for graceful zero-handling.
ROUNDDOWN composes freely with IF, MAX, MIN, and other functions. Excel's tools nest well.
Should I use ROUNDDOWN, TRUNC, or INT for financial reporting?
For non-negative revenue and expenses: any of the three works, pick whichever reads clearest. TRUNC is shortest; ROUNDDOWN has explicit decimal-place control; INT is a one-word function name.
For P&L numbers that can go negative (losses, refunds, adjustments): decide the intent. If "round down = smaller absolute magnitude" (conservative loss reporting), use ROUNDDOWN or TRUNC. If "round down = more negative" (true mathematical floor), use INT.
Does ROUNDDOWN affect performance in large workbooks?
No — ROUNDDOWN is fast and non-volatile. Excel evaluates hundreds of thousands per second. If a workbook is slow, the cause is almost never ROUNDDOWN; look at volatile functions (NOW, RAND, INDIRECT), massive lookups, or unnecessary recalculation triggers.
Templates That Use ROUNDDOWN
Budget Calculator
Budget ÷ item price = items you can actually afford. ROUNDDOWN ensures you never over-commit past your budget.
USES ROUNDDOWNTax Deduction Tracker
IRS-safe truncation on every deductible. Guarantees you never over-claim by even a fractional cent — audit-safe conservative reporting.
USES ROUNDDOWNInventory Safe Count
Available-to-promise counts truncated down. Never oversell what you can't ship. Combines with reorder-point logic.
USES ROUNDDOWNSalary Cap Analyzer
How many hires fit under a total cap? ROUNDDOWN(cap ÷ avg_salary, 0) gives the conservative headcount you can guarantee.
USES ROUNDDOWNBulk Purchase Optimizer
Match orders to case sizes without exceeding budget or storage. ROUNDDOWN keeps quantities feasible on both constraints.
USES ROUNDDOWNRetirement Contribution Planner
Yearly limit ÷ pay periods = per-period contribution, ROUNDDOWNed. Prevents accidental over-contribution that triggers IRS penalties.
USES ROUNDDOWNGrade Boundary Calculator
Percentage to letter-grade lookup that uses ROUNDDOWN so students at the 89.9% boundary get a B+, not an A- by accident.
USES ROUNDDOWNLoan Payoff Tracker
Months-to-payoff calculation using ROUNDDOWN on the intermediate balance division — matches the conservative bank-side accounting.
Truncate Safely, Report Conservatively, Sleep Better
Excel Wizard writes ROUNDDOWN patterns — budget-safe item counts, tax-truncation, INT-vs-TRUNC decisions — from a plain-English prompt. Never over-claim, never oversell, never over-commit. Right inside Excel.
Get Excel Wizard Add-in →