# Excel ROUNDDOWN function

## Summary

The Excel ROUNDDOWN function rounds a number down, toward zero, to a specified number of digits. It’s especially useful in scenarios where you need to decrease a number to the nearest specified decimal or integer without rounding up, such as in financial calculations or when working with specific measurement standards.
##### Syntax
```				```
=ROUNDDOWN(number, num_digits)
```
```
• number: The number to round down
• num_digits: The number of digits to which you want to round down the number
##### Return value
The number rounded down to the specified number of digits.

## How to use

Use ROUNDDOWN by inputting the number to be rounded and specifying the number of digits for rounding. If num_digits is greater than 0, the function rounds down to the specified number of decimal places. If num_digits is 0, it rounds down to the nearest integer. If num_digits is less than 0, it rounds down to the left of the decimal point.

## Examples

##### Simple ROUNDDOWN

Rounding Down to a Specific Decimal Place: To round a number down to two decimal places:

```				```
=ROUNDDOWN(3.14159, 2)
```
```
This formula rounds 3.14159 down to 3.14.
##### ROUNDDOWN to Tens and Hundreds

Rounding down with negative num_digits: Rounding a number down to the nearest ten:

```				```
=ROUNDDOWN(157, -1)
```
```
Rounds 157 down to 150.
##### ROUNDDOWN for Clean Display
Rounding Down Inventory Counts: Applying ROUNDDOWN in inventory calculations:
```				```
=ROUNDDOWN(Quantity, 0)
```
```
Rounds down the Quantity to the nearest whole number, useful for inventory counts where partial items are not counted.