ROUNDDOWN Function in Excel — The "Always Toward Zero" Rule (2026) | Sheets & Cells
Math · Rounding Family

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.

Universal Support
ROUNDDOWN has existed in Excel since Excel 1.0 (1985). Works identically in Excel 2003, 2007, 2010, 2013, 2016, 2019, 2021, Microsoft 365, Excel Online, Excel Mobile, Google Sheets, and LibreOffice Calc. No compatibility caveats.

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.

ROUNDDOWN moves toward smaller absolute value. Positive numbers go down. Negative numbers go up. Both move closer to zero — never further away.

Positive numbers — go DOWN

1.1→1
1.999→1
4.7→4
99.99→99

Negative numbers — go UP

-1.1→-1
-1.999→-1
-4.7→-4
-99.99→-99
This is truncation. The fractional part is discarded, the sign is kept. Same behavior as TRUNC — very different from INT (which floors toward negative infinity). See the confused-trio comparison below.

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.

=ROUNDDOWN(number, num_digits)

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.

↓ Download .xlsx (Free)
Filerounding-family-2026.xlsx
Size~23 KB
Sheets6 tabs
CoversROUND · ROUNDUP · ROUNDDOWN
1985
Introduced
2
Arguments
100%
Compat
50+
Templates Use It

Syntax

ROUNDDOWN takes exactly two arguments — identical shape to ROUND and ROUNDUP.

ArgumentTypeDescription
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

Example 01

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.

ValueFormulaTruncatedCents 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.

Example 02

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.

=ROUNDDOWN(budget / item_price, 0)
BudgetItem PriceRaw DivisionItems You Can Buy
$100$24.994.00164
$500$149.993.33363
$250$47.8335.22665
$50$18.4752.70632
$1,000$249.9954.00014

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.

Example 03

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.

InputFormulaResultDirection
1.1=ROUNDDOWN(1.1, 0)1positive → down (toward 0)
1.9=ROUNDDOWN(1.9, 0)1positive → down (toward 0)
-1.1=ROUNDDOWN(-1.1, 0)-1negative → UP (toward 0)
-1.9=ROUNDDOWN(-1.9, 0)-1negative → UP (toward 0)
0=ROUNDDOWN(0, 0)0zero 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.

Example 04

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.7444
4.999444
0.5000
-0.5-100
-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.

Example 05

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.

InvoiceTotal (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
A2 → 24.99
A3 → -24.99
A4 → 100 ÷ 24.99 budget
A5 → 1245.87
A6 → -4.7 (compare all 3)
Formula & Result
=ROUNDDOWN(A2, 0)
24
=ROUNDDOWN(A3, 0)
-24
=ROUNDDOWN(100/24.99, 0)
4 items
=ROUNDDOWN(A5, -2)
1200
=ROUNDDOWN(-4.7, 0) vs INT(-4.7)
-4 vs -5

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.

The split: INT is mathematical floor — always moves toward negative infinity. ROUNDDOWN and TRUNC are truncation — always move toward zero. For non-negative data they're interchangeable. For anything that might go negative, the choice matters.
Input=INT(x)=TRUNC(x)=ROUNDDOWN(x, 0)
4.7444
4.001444
4.999444
0000
-0.5-100
-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.

AspectROUNDDOWNFLOOR / 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

SymptomCauseFix
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.

↓ Get Workbook

Related Functions

Compatibility

PlatformSupportedVersionNotes
Excel for Windows✓1.0+ (1985)All versions
Excel for Mac✓1.0+All versions
Microsoft 365✓CurrentFull support
Excel Online✓CurrentFull support
Excel Mobile (iOS/Android)✓CurrentFull support
Google Sheets✓AllIdentical behavior
LibreOffice Calc✓AllIdentical behavior

How to Use ROUNDDOWN — Step by Step

  1. Click an empty cell where the truncated value should appear.
  2. Type =ROUNDDOWN( — Excel auto-suggests as soon as you type "ROUND".
  3. Reference the source or type a value, then add a comma and the number of decimal places: =ROUNDDOWN(A2, 0) for whole numbers.
  4. Close with ) and press Enter.
  5. For budget math, use: =ROUNDDOWN(budget / item_price, 0). You get the exact integer number of items you can afford — no fractional pretending.
  6. For tax-deductible truncation, use: =ROUNDDOWN(deductible_amount, 0). Audit-safe — you never claim a fractional cent you can't prove.
  7. 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.

↓ Download Free

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.

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 →