Math · rounding · Nov 2026

The FLOOR function,
measured & explained.

A measured FLOOR gallery: down-to-multiple rounding, the same-sign rule and the mode-argument gotcha — every assertion engine-verified. Live, free.

D1
fx
=FLOOR(2.5,1)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How FLOOR works

Rounds down, toward zero, to the nearest multiple of significance.

=FLOOR(number, significance, [mode])
numberThe value to round down to a multiple.
significanceThe multiple; keep the same sign as number for portability.
modeOptional; direction for mixed signs (unsupported in HyperFormula).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Down to a multiple

What FLOOR actually returns

FLOOR rounds down to the nearest multiple of a significance, toward zero. It is the multiple-aware cousin of ROUNDDOWN. Every row measured live in HyperFormula. Click any row to load it.

Floor gallery — down to a multiple

ExpressionResultWhy
=FLOOR(2.5,1)2Down to the multiple below
=FLOOR(10,3)9Multiple of 3 below 10
=FLOOR(-2.5,-1)-2Same-sign: toward zero
=FLOOR(1234,100)1200Hundred below
=FLOOR(7,1)7Exact multiple unchanged
=FLOOR(9.99,0.5)9.5Half multiple below
=FLOOR(12,5)10Multiple of 5 below
=FLOOR(0.99,0.1)0.9Tenth below

FLOOR vs CEILING vs MROUND on 10, multiple 3

ExpressionResultWhy
=FLOOR(10,3)9Forced down
=CEILING(10,3)12Forced up
=MROUND(10,3)9Nearest

Sign and the mode argument

ExpressionResultWhy
=FLOOR(-2.5,-1)-2Same sign: toward zero (works)
=FLOOR(-2.5,1)-3 hereHF away-from-zero; Excel needs a mode arg
=FLOOR(-2.5,1,-1)#N/A heremode arg unsupported in HyperFormula
⚠ For a negative number with a positive significance, Excel's FLOOR uses a third mode argument. HyperFormula 3.5 does not support mode (returns #N/A) and computes FLOOR(-2.5,1)=-3. Keep number and significance the same sign for portable results.
Use FLOOR to never over-shoot a multiple: whole cartons you can fill, conservative price tiers, completed billing blocks. Same-sign arguments behave identically everywhere.
// 03 — Try it live

Interactive FLOOR playground

Same-sign presets are exact and engine-stable; the mode-argument deviation is documented.

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 FLOOR works

FLOOR is universal; same-sign arguments behave identically across Excel, Google Sheets and LibreOffice. The mode argument varies by platform.

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

Master multiples

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

  • FLOOR vs CEILING vs MROUND direction
  • The same-sign rule and mode gotcha
  • Conservative tier and pack rounding
  • When forced-down multiples are right
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked