Math · rounding · Nov 2026

The ROUNDDOWN function,
measured & explained.

A measured ROUNDDOWN gallery: toward-zero direction, negatives, negative digits and the ROUNDDOWN-vs-TRUNC-vs-INT distinction — every assertion engine-verified. Live, free.

D1
fx
=ROUNDDOWN(3.9,0)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How ROUNDDOWN works

Two arguments. Always rounds toward zero, dropping the fraction.

=ROUNDDOWN(number, num_digits)
numberThe value to round toward zero.
num_digitsPlace: >0 decimals, 0 integer, <0 tens/hundreds/thousands.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Always toward zero

What ROUNDDOWN actually returns

ROUNDDOWN forces the magnitude down, toward zero, dropping any fraction. Positive numbers shrink toward 0, negative numbers rise toward 0. Every row measured live in HyperFormula. Click any row to load it.

Direction gallery — toward zero

ExpressionResultWhy
=ROUNDDOWN(3.9,0)3Any fraction is dropped, toward zero
=ROUNDDOWN(-3.9,0)-3Negative: toward zero is less negative
=ROUNDDOWN(3.14159,2)3.142 decimals, chop the rest
=ROUNDDOWN(1234,-2)1200-2 rounds down to the hundred below
=ROUNDDOWN(7,0)7Exact integer unchanged
=ROUNDDOWN(-0.9,0)0Toward zero lands on 0
=ROUNDDOWN(9.99,1)9.91 decimal, drop the hundredths
=ROUNDDOWN(1234,-3)1000-3 rounds down to the thousand below

ROUNDDOWN vs TRUNC vs INT on negatives (the key distinction)

ExpressionResultWhy
=ROUNDDOWN(-3.7,0)-3Toward zero
=TRUNC(-3.7)-3Also toward zero — identical here
=INT(-3.7)-4 in ExcelINT floors (more negative); this HF engine returns -3

Round down to a multiple (floor trick)

ExpressionResultWhy
=ROUNDDOWN(10/3,0)*39Divide, round down, multiply back = multiple of 3 below
=FLOOR(10,3)9FLOOR does the same in one call
⚠ ROUNDDOWN and TRUNC are identical for the basic case (both toward zero). The trap is INT: in real Excel INT(-3.7)=-4 (it floors), while ROUNDDOWN(-3.7,0)=-3. Note this HyperFormula playground computes INT as -3, a known engine deviation — trust ROUNDDOWN/TRUNC for toward-zero here.
Use ROUNDDOWN when you must never over-estimate: whole units you can afford, completed items, conservative budgets. For a multiple, prefer FLOOR.
// 03 — Try it live

Interactive ROUNDDOWN playground

All presets are exact and engine-stable; the INT comparison notes a documented HyperFormula deviation.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where ROUNDDOWN works

ROUNDDOWN is universal across all Excel versions, Google Sheets and LibreOffice Calc with identical toward-zero behaviour.

PlatformSupportNotesGotcha
✓ Supported full ROUNDDOWN◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master rounding

ROUNDDOWN is one piece. The full course walks the toolkit end to end with live, measured examples.

  • ROUNDDOWN vs ROUND vs ROUNDUP direction
  • ROUNDDOWN vs TRUNC vs INT on negatives
  • Round down to a multiple with FLOOR
  • Conservative estimation with toward-zero rounding
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked