ROUNDDOWN

When rounding in Excel, you often need to round numbers down – to whole numbers or several decimal places.

The ROUNDDOWN function is used to always round numbers “down”. Its difference from ROUND is that regardless of the digit after the rounding position, the rounded part of the number always remains the same.

Syntax and arguments of the function

=ROUNDDOWN(Number, Num_digits)

When the second argument is zero, rounding to whole numbers is performed. If the argument is made negative (-1, -2, -3…), the number is rounded to tens, hundreds, thousands, etc.

Example formula with the ROUNDDOWN function

The formula below rounds down the value of cell A1 to two decimal places.

=ROUNDDOWN(A1, 2)

Round down procedure in Excel

There are often situations when you need to round many numbers in a table at once – an entire column or row. In this case, you need to actually perform the rounding procedure, not just change the number of visible digits.

Excel doesn’t have this capability, so I decided to add it to my Excel add-in. You can either choose or enter yourself the number of digits before and after the decimal point. See how it works:

This post is also available in RU.