Kornilios Ampatzis/ April 19, 2019/ Functions

It rounds a number down to a specified number of digits.

The syntax of the function is the following:

ROUNDDOWN(number, digits)

number: The number you want to round down.
digits: The number of digits to which you want to round down the number.

If digits is greater than 0 (zero), then number is rounded down to the specified number of decimal places.

If digits is 0, the number is rounded down to the nearest integer.

If digits is less than 0, the number is rounded down to the left of the decimal point.

If you don’t want to round always down then use the ROUND function.

To always round up, use the ROUNDUP function.

To round a number to a specific multiple, use the MROUND function.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the ROUNDDOWN function:

Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded down with 2 decimal places.

Share this Post