A measured FLOOR gallery: down-to-multiple rounding, the same-sign rule and the mode-argument gotcha — every assertion engine-verified. Live, free.
Rounds down, toward zero, to the nearest multiple of significance.
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.
| Expression | Result | Why |
|---|---|---|
| =FLOOR(2.5,1) | 2 | Down to the multiple below |
| =FLOOR(10,3) | 9 | Multiple of 3 below 10 |
| =FLOOR(-2.5,-1) | -2 | Same-sign: toward zero |
| =FLOOR(1234,100) | 1200 | Hundred below |
| =FLOOR(7,1) | 7 | Exact multiple unchanged |
| =FLOOR(9.99,0.5) | 9.5 | Half multiple below |
| =FLOOR(12,5) | 10 | Multiple of 5 below |
| =FLOOR(0.99,0.1) | 0.9 | Tenth below |
| Expression | Result | Why |
|---|---|---|
| =FLOOR(10,3) | 9 | Forced down |
| =CEILING(10,3) | 12 | Forced up |
| =MROUND(10,3) | 9 | Nearest |
| Expression | Result | Why |
|---|---|---|
| =FLOOR(-2.5,-1) | -2 | Same sign: toward zero (works) |
| =FLOOR(-2.5,1) | -3 here | HF away-from-zero; Excel needs a mode arg |
| =FLOOR(-2.5,1,-1) | #N/A here | mode arg unsupported in HyperFormula |
Same-sign presets are exact and engine-stable; the mode-argument deviation is documented.
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.
FLOOR is universal; same-sign arguments behave identically across Excel, Google Sheets and LibreOffice. The mode argument varies by platform.
| Platform | Support | Notes | Gotcha |
|---|
FLOOR is one piece. The full course walks the toolkit end to end with live, measured examples.