Excel ROUNDDOWN Function

Related Functions:
ROUND
ROUNDUP
TRUNC

Basic 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 listed in the following table:

number-The initial number.
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

The following spreadsheets show examples of the Excel Rounddown function:

 Formulas:
 AB
199.999=ROUNDDOWN( A1, 1 )
299.999=ROUNDDOWN( A2, 2 )
399.999=ROUNDDOWN( A3, 0 )
499.999=ROUNDDOWN( A4, -1 )
5-99.999=ROUNDDOWN( A5, 2 )
6-99.999=ROUNDDOWN( A6, -1 )
 Results:
 AB
199.99999.9
299.99999.99
399.99999
499.99990
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.


Further information on the Excel Rounddown Function is provided on the Microsoft Office website. Also, a comparison of the Excel Rounding Functions is provided on the Excel Rounding Functions page.