What is the ROUNDDOWN Function
The ROUNDDOWN function rounds a number down to a specified number of decimal places. Unlike ROUND, it always moves toward zero, never rounding up.
Formula: =ROUNDDOWN(number, num_digits)
Practical Example 1
A2 contains 3.149.
Type: =ROUNDDOWN(A2, 2)
Result: 3.14
Practical Example 2
Round down to the nearest integer.
Type: =ROUNDDOWN(A2, 0)
Result: 3
Practical Example 3
Calculate a discount without rounding up.
Type: =ROUNDDOWN(A2 * 0.9, 2)
Result: the discounted price rounded down
When to Use It
ROUNDDOWN is used for calculating discounts, for conservative financial estimates, for rounding down prices, and for any formula where you want to always round toward zero.