➕ Math Function · beginner
ROUNDDOWN Function in Google Sheets
Rounds a number TOWARD zero to a specified number of decimal places.
Syntax
ROUNDDOWN(value, [places])Returns: value rounded toward zero.
Excel equivalent: ROUNDDOWN (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| value | Required | Number to round. |
| places | Optional | Decimal places. Default 0. |
Examples
Truncate to dollars
=ROUNDDOWN(A2, 0)1.99 → 1, -1.99 → -1.
Next hundred down
=ROUNDDOWN(A2, -2)1247 → 1200.
When to use an alternative
- ROUNDUP — Opposite direction.
- FLOOR — Multiple of arbitrary unit.
- INT — Toward negative infinity.
- TRUNC — Discard decimals.
Common errors and how to fix them
Confused with INT
Cause: Differ for negatives.
Fix: ROUNDDOWN toward zero; INT toward negative infinity.
Related functions
ROUND
Rounds a number to a specified number of decimal places using standard half-away-from-zero rounding....
ROUNDUP
Rounds a number AWAY from zero to a specified number of decimal places....
ABS
Returns the absolute value of a number....
MOD
Returns the remainder of a division. Used for divisibility tests, cycles, and conditional formatting...
SUM
Adds up numbers in a range or list of values. The first function nearly every spreadsheet user learn...
Frequently Asked Questions
ROUNDDOWN vs INT?
For positives identical. ROUNDDOWN(-2.5) = -2; INT(-2.5) = -3.
Same as TRUNC?
Nearly — TRUNC(x, n) ≡ ROUNDDOWN(x, n).