Excel Function: ROUNDDOWN

The Excel function ROUNDDOWN allows you to round a number to its lower value based on the chosen number of decimals.


=ROUNDDOWN(number, num_digits)

Usage Example

Select the ROUNDDOWN function and enter:

rounddown function

Click OK.

The number is rounded.


Then simply drag the formula down:

rounddown autofill