ROUNDDOWN function

Excel ROUNDDOWN Function is a handy tool that helps you round a number down to a specified number of decimal places. This can be useful when you want to truncate a number to a certain precision or simplify calculations.


ROUNDDOWN(number, [num_digits])


numberThe number you want to round down.
[num_digits]The number of decimal places to which you want to round down. If this argument is negative, it will round down to the left of the decimal point. (Optional)

How to Use

Let’s dive into how to use the ROUNDDOWN function with a few examples:

Example 1: Rounding down to a specific number of decimal places

In this example, we are rounding the number 12.3456 down to 2 decimal places, resulting in 12.34.

Example 2: Rounding down to the nearest integer

Here, we are rounding down 15.789 to the nearest whole number, which gives us 15.

Example 3: Rounding down to the left of the decimal point

In this case, we’re rounding down 12345 to the nearest hundred, resulting in 12300.

Example 4: Using the optional argument

By specifying -3 as the num_digits argument, we’re rounding down to the thousands, giving us 9000.

Additional Information

It’s important to note that the ROUNDDOWN function always rounds down towards negative infinity. This means it will reduce the value of the number, making it less than or equal to the original number, and it does not round up.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.