Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inROUNDDOWN(number, num_digits)
TRUNC(number, [num_digits]) gives the same result.
Google Sheets✔ Built inROUNDDOWN(value, [places])
Airtable✔ Built inROUNDDOWN(value, precision)
Notion≈ Workaroundsign(n) * floor(abs(n) * 100) / 100
Notion 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 ↗
AirtableROUNDDOWN(3.789, 1)
Notion
workaround
sign(3.789) * floor(abs(3.789) * 10) / 10

Arguments

ArgumentWhat it means
numberThe value to round.
num_digitsDecimal places to keep; negative rounds to tens, hundreds…

Examples

FormulaResultWhyCopy
=ROUNDDOWN(3.789, 1)3.7Extra digits are dropped.
=ROUNDDOWN(-3.789, 1)-3.7Toward zero for negatives too.
=ROUNDDOWN(A2/60, 0)Whole hoursFull 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) and ROUNDDOWN(x, n) return the same value; TRUNC just makes the digits argument optional.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.