Excel: RoundDown Function

In Excel, the RoundDown function returns a number rounded down to a specified number of digits. (Always rounds towards 0.)

The syntax for the RoundDown function is:

RoundDown( number, digits )

number is the number to round down.

digits is the number of digits to round the number down to.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=RoundDown(A1, 0) would return 662

=RoundDown(A1, 1) would return 662.7

=RoundDown(A2, -1) would return 50

=RoundDown(55.1, -1) would return 50

=RoundDown(-23.67, 1) would return -23.6