Summary
The Excel ROUNDDOWN function rounds a number down, toward zero, to a specified number of digits. It’s especially useful in scenarios where you need to decrease a number to the nearest specified decimal or integer without rounding up, such as in financial calculations or when working with specific measurement standards.
Syntax
=ROUNDDOWN(number, num_digits)
- number: The number to round down
- num_digits: The number of digits to which you want to round down the number
Return value
The number rounded down to the specified number of digits.
How to use
Use ROUNDDOWN by inputting the number to be rounded and specifying the number of digits for rounding. If num_digits is greater than 0, the function rounds down to the specified number of decimal places. If num_digits is 0, it rounds down to the nearest integer. If num_digits is less than 0, it rounds down to the left of the decimal point.
Examples
Simple ROUNDDOWN
Rounding Down to a Specific Decimal Place: To round a number down to two decimal places:
=ROUNDDOWN(3.14159, 2)
This formula rounds 3.14159 down to 3.14.
ROUNDDOWN to Tens and Hundreds
Rounding down with negative num_digits: Rounding a number down to the nearest ten:
=ROUNDDOWN(157, -1)
Rounds 157 down to 150.
ROUNDDOWN for Clean Display
Rounding Down Inventory Counts: Applying ROUNDDOWN in inventory calculations:
=ROUNDDOWN(Quantity, 0)
Rounds down the Quantity to the nearest whole number, useful for inventory counts where partial items are not counted.
Additional Notes
- ROUNDDOWN always rounds numbers down (towards zero), making it distinct from the general ROUND function.
- It’s valuable in situations where you need to conservatively estimate or adjust numbers.