Math and statistics
ROUNDDOWN function playground
Always rounds a number down, toward zero, by dropping digits.
The playground runs in your browser. Nothing you type is sent anywhere.
How ROUNDDOWN works
ROUNDDOWN simply cuts off the digits after the place you choose. 67.99 rounded down to 0 digits is 67.
Use it when only complete units count, such as full years of service or full boxes you can fill.
Syntax
=ROUNDDOWN(number, num_digits)| Argument | What it means |
|---|---|
numberrequired | The number to round down. |
num_digitsrequired | Digits to keep. 0 = whole number, negative = to the left of the decimal point. |
Examples
| Formula | What it does | Result |
|---|---|---|
=ROUNDDOWN(D2,0) | Drop the cents from the sale price. | 67 |
=ROUNDDOWN(D2,1) | Keep one decimal place. | 67.9 |
=ROUNDDOWN(B6,-1) | Round down to the nearest 10. | 180 |
=ROUNDDOWN(-2.9,0) | Toward zero: -2. | -2 |
Common mistakes
Negative numbersROUNDDOWN moves toward zero, so -2.9 becomes -2.
INT is different for negativesINT(-2.9) is -3 because INT always goes down the number line.
Related functions
Learn more
Download the example workbook (.xlsx)
The workbook has the same sample data and formulas, plus a practice sheet.