# How to Use ROUNDDOWN Function in Excel (With Examples)

If you’re looking to round numbers down to a specified decimal place, Excel’s ROUNDDOWN function is your go-to tool. This article will explore how to use the function with examples. Without further ado, let’s begin!

## Using the ROUNDDOWN Function in Excel

ROUNDDOWN Functionâ€™s Syntax =ROUNDDOWN(number, num_digits)

Excel’s ROUNDDOWN function requires two arguments: the numerical figure to be rounded (number) and the number of decimal places (num_digits). This efficient, easy-to-use tool then rounds your desired number down towards zero with exactitude at the given decimal point amount.

Here are the steps to use the ROUNDDOWN function in Excel:

1. Start by entering ROUNDDOWN( in a cell.
2. For the initial argument, input the number figure to be rounded.
3. For the second argument, enter the number of decimal places to which the number should be rounded.
4. Close the parentheses. Press Enter to get the result.

Example: Let’s assume you have the number -46.0372741 in cell A2, which you want to round down. You can use the ROUNDDOWN function in Excel as follows:

Round down to 1 decimal place =ROUNDDOWN(A2,1)

Round down to 2 decimal places =ROUNDDOWN(A2,2)

Round down to 3 decimal places =ROUNDDOWN(A2,3)

Round down to Nearest Integer =ROUNDDOWN(A2,0)

Round down to Nearest 10 value =ROUNDDOWN(A2,-1)

After entering each formula, press Enter to get the value.

## Conclusion

As you see, the ROUNDDOWN function in Excel makes it easy to round numbers down to a specific decimal place. So now you know how to use ROUNDDOWN, try it out today and see how it works for your project. Good luck!