Skip to main content



Rounds a number down, toward zero.


ROUNDDOWN(number, num_digits)

The ROUNDDOWN function syntax has the following arguments:

  • Number    Required. Any real number that you want rounded down.

  • Num_digits    Required. The number of digits to which you want to round number.


  • ROUNDDOWN behaves like ROUND, except that it always rounds a number down.

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

  • If num_digits is 0, then number is rounded down to the nearest integer.

  • If num_digits is less than 0, then number is rounded down to the left of the decimal point

In order to use the ROUNDDOWN formula, type in the values for in a cell as shown below:



User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.