Excel Function: ROUNDDOWN
The Excel function ROUNDDOWN allows you to round a number to its lower value based on the chosen number of decimals.
Usage:
=ROUNDDOWN(number, num_digits)
Usage Example
Select the ROUNDDOWN function and enter:
- Number: the number to round
- Num_digits: the desired number of decimals
=ROUNDDOWN(A2,2)
![rounddown function](https://www.excel-pratique.com/view/en/functions/img/rounddown/rounddown_function.png)
Click OK.
The number is rounded.
![rounddown](https://www.excel-pratique.com/view/en/functions/img/rounddown/rounddown.png)
Then simply drag the formula down:
![rounddown autofill](https://www.excel-pratique.com/view/en/functions/img/rounddown/rounddown_autofill.png)