ROUNDDOWN Function in Excel, Google Sheets, Airtable & Notion
ROUNDDOWN rounds toward zero, simply dropping the extra digits: 3.789 to one decimal is 3.7 and −3.789 is −3.7. It behaves like TRUNC.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | ROUNDDOWN(number, num_digits)TRUNC(number, [num_digits]) gives the same result. |
| Google Sheets | ✔ Built in | ROUNDDOWN(value, [places]) |
| Airtable | ✔ Built in | ROUNDDOWN(value, precision) |
| Notion | ≈ Workaround | sign(n) * floor(abs(n) * 100) / 100Notion has floor() (toward −∞); use it on the absolute value to round toward zero. |
Try ROUNDDOWN with your own values
Result (as Excel & Google Sheets return it)
3.7
Your formula, ready to paste
| Excel | =ROUNDDOWN(3.789, 1) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =ROUNDDOWN(3.789, 1) | open sheets.new ↗ |
| Airtable | ROUNDDOWN(3.789, 1) | |
| Notion workaround | sign(3.789) * floor(abs(3.789) * 10) / 10 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The value to round. |
num_digits | Decimal places to keep; negative rounds to tens, hundreds… |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=ROUNDDOWN(3.789, 1) | 3.7 | Extra digits are dropped. | |
=ROUNDDOWN(-3.789, 1) | -3.7 | Toward zero for negatives too. | |
=ROUNDDOWN(A2/60, 0) | Whole hours | Full hours in A2 minutes. |
Examples use Excel / Google Sheets syntax unless noted.
How ROUNDDOWN works
ROUNDDOWN is useful whenever only complete units count: whole years of age, full hours worked, complete sets that can be made from stock. It never rounds up, so 9.999 to zero places is 9.
For positive numbers ROUNDDOWN(x, 0) and INT agree. For negative numbers they differ: ROUNDDOWN(−3.7, 0) is −3 (toward zero) but INT(−3.7) is −4 (toward −∞). Pick the one that matches what “down” means in your problem.
Frequently Asked Questions
- Is ROUNDDOWN the same as TRUNC?
- Yes. In Excel and Google Sheets,
TRUNC(x, n)andROUNDDOWN(x, n)return the same value; TRUNC just makes the digits argument optional.