ROUND rounds a number to a set number of digits — halves go away from zero. Negative digits round to tens, hundreds, thousands. This page measures ROUND against ROUNDUP, ROUNDDOWN and TRUNC so you can see exactly which direction each takes.
Returns a number. Halves round away from zero (2.5→3, -2.5→-3). Negative num_digits rounds left of the decimal.
Same number, five functions, five answers. ROUND goes to the nearest (halves away from zero); ROUNDUP/ROUNDDOWN force a direction; TRUNC chops toward zero. Every row was measured live in HyperFormula. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =ROUND(3.14159,2) | 3.14 | Nearest hundredth |
| =ROUND(2.5,0) | 3 | Half rounds away from zero |
| =ROUND(-2.5,0) | -3 | Negative half rounds to -3, not -2 |
| =ROUNDUP(3.21,1) | 3.3 | Always away from zero |
| =ROUNDDOWN(3.89,1) | 3.8 | Always toward zero |
| =ROUND(1234.5,-2) | 1200 | Negative digits round to hundreds |
| =TRUNC(-3.7) | -3 | Chops the decimal toward zero |
| =ROUND(999,-3) | 1000 | Negative digits round to thousands |
| Expression | Result | Why |
|---|---|---|
| =ROUND(1234.5,-1) | 1230 | -1 → tens |
| =ROUND(1234.5,-2) | 1200 | -2 → hundreds |
| =ROUND(999,-3) | 1000 | -3 → thousands |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see ROUND go to the nearest, force a direction with ROUNDUP/ROUNDDOWN, and round to hundreds with negative digits.
8 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.
ROUND, ROUNDUP, ROUNDDOWN and TRUNC are available in Excel 2003+, Microsoft 365, Excel for the web and Google Sheets. Excel's INT floors negatives (INT(-3.7)=-4); this page's live engine truncates, so INT negative cases are prose-only.
| Platform | Support | Notes | Gotcha |
|---|
ROUND is one piece. The full course walks the toolkit end to end with live, measured examples.