A measured ROUNDDOWN gallery: toward-zero direction, negatives, negative digits and the ROUNDDOWN-vs-TRUNC-vs-INT distinction — every assertion engine-verified. Live, free.
Two arguments. Always rounds toward zero, dropping the fraction.
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.
| Expression | Result | Why |
|---|---|---|
| =ROUNDDOWN(3.9,0) | 3 | Any fraction is dropped, toward zero |
| =ROUNDDOWN(-3.9,0) | -3 | Negative: toward zero is less negative |
| =ROUNDDOWN(3.14159,2) | 3.14 | 2 decimals, chop the rest |
| =ROUNDDOWN(1234,-2) | 1200 | -2 rounds down to the hundred below |
| =ROUNDDOWN(7,0) | 7 | Exact integer unchanged |
| =ROUNDDOWN(-0.9,0) | 0 | Toward zero lands on 0 |
| =ROUNDDOWN(9.99,1) | 9.9 | 1 decimal, drop the hundredths |
| =ROUNDDOWN(1234,-3) | 1000 | -3 rounds down to the thousand below |
| Expression | Result | Why |
|---|---|---|
| =ROUNDDOWN(-3.7,0) | -3 | Toward zero |
| =TRUNC(-3.7) | -3 | Also toward zero — identical here |
| =INT(-3.7) | -4 in Excel | INT floors (more negative); this HF engine returns -3 |
| Expression | Result | Why |
|---|---|---|
| =ROUNDDOWN(10/3,0)*3 | 9 | Divide, round down, multiply back = multiple of 3 below |
| =FLOOR(10,3) | 9 | FLOOR does the same in one call |
All presets are exact and engine-stable; the INT comparison notes a documented HyperFormula deviation.
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.
ROUNDDOWN is universal across all Excel versions, Google Sheets and LibreOffice Calc with identical toward-zero behaviour.
| Platform | Support | Notes | Gotcha |
|---|
ROUNDDOWN is one piece. The full course walks the toolkit end to end with live, measured examples.