Excel ROUNDDOWN function


The Excel ROUNDDOWN function returns a number rounded down to the specified number of digits.


=ROUNDDOWN(number, num_digits)

Arguments (inputs)

number = the number to round, can be a number or a cell reference

num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.

Return value

The ROUNDDOWN function returns numerical value that is the rounded down value of the number provided.


Excel ROUNDDOWN function example

In the example above the ROUNDDOWN function rounds the prices in column E down to the next lowest integer (0 instructs the ROUNDUP function to round to the integer).


The result returned in cell G6 is $261.