Excel ROUNDDOWN Function

Related Functions:
ROUND
ROUNDUP
TRUNC

Function Description

The Excel Rounddown function rounds a supplied number down towards zero, to a specified number of decimal places.

The syntax of the function is:

ROUNDDOWN( number, num_digits )

Where the arguments are as follows:

number - The number to be rounded.
num_digits -

The number of decimal places to round the supplied number to.

Note that:

  • A positive num_digits value specifies the number of digits to the right of the decimal point;
  • A num_digits value of 0 specifies rounding to the nearest integer;
  • A negative num_digits value specifies the number of digits to the left of the decimal point.

Rounddown Function Examples

Column B of following spreadsheet shows several examples of the Excel Rounddown function:

 Formulas:
  A B
1 99.999 =ROUNDDOWN( A1, 1 )
2 99.999 =ROUNDDOWN( A2, 2 )
3 99.999 =ROUNDDOWN( A3, 0 )
4 99.999 =ROUNDDOWN( A4, -1 )
5 -99.999 =ROUNDDOWN( A5, 2 )
6 -99.999 =ROUNDDOWN( A6, -1 )
 Results:
  A B
1 99.999 99.9
2 99.999 99.99
3 99.999 99
4 99.999 90
5 -99.999 -99.99
6 -99.999 -90

The above examples show how the Rounddown function always rounds down towards zero. I.e. a positive number becomes less positive and a negative number becomes less negative.

If you require different rounding rules, check out our comparison of Excel Rounding Functions.

See the Microsoft Office website for further details and examples of the Excel Rounddown Function.