Syntax
=ROUNDDOWN(value, [places])
value- The number to round.
places- Optional. Decimal places to keep (default 0).
ROUNDDOWN function in Google Sheets
ROUNDDOWN always rounds toward zero, which simply chops off digits. Use it when only complete units count: full hours, whole years, finished batches.
Practice ROUNDDOWN
Task 1 of 1
Only full hours are billable. Round the hours in B2 down to a whole number. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
ROUNDDOWN examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | |
|---|---|---|
| 1 | Value | Other |
| 2 | -7.45 | 3 |
| 3 | 12.5 | 4 |
| 4 | 81 | 2 |
| 5 | 2.5 | 0 |
| 6 | 1234.567 | 5 |
| Formula | Result | What it shows |
|---|---|---|
=ROUNDDOWN(A6, 1) | 1234.5 | Keeps one decimal, drops the rest. |
=ROUNDDOWN(A2, 0) | -7 | Toward zero: -7.45 becomes -7. |
=ROUNDDOWN(A3, -1) | 10 | Down to the nearest ten. |
Tips and common mistakes
- For positive numbers ROUNDDOWN(x, 0) and INT(x) give the same result. For negatives they differ, because INT rounds down (away from zero).
Related functions
Learning step by step? ROUNDDOWN is covered in Lesson 30: ROUND, ROUNDUP & ROUNDDOWN of the free course.