The `ROUNDDOWN` function in Excel is used to round a number down towards zero, to a specified number of decimal places. Here’s the syntax for the `ROUNDDOWN` function:
ROUNDDOWN(number, num_digits)
- number: This is the number you want to round down.
- num_digits: This indicates the number of decimal places to which you want to round down the number. If `num_digits` is greater than 0, the number is rounded down to the specified number of decimal places. If `num_digits` is 0, the number is rounded down to the nearest integer. If `num_digits` is less than 0, the number is rounded down to the left of the decimal point.
Examples:
- Rounding Down to a Specific Decimal Place:
- Formula: `=ROUNDDOWN(3.567, 2)`
- Result: `3.56`
- This rounds the number 3.567 down to 3.56 (two decimal places).
- Rounding Down to the Nearest Integer:
- Formula: `=ROUNDDOWN(7.89, 0)`
- Result: `7`
- This rounds the number 7.89 down to 7 (the nearest integer).
- Rounding Down to Tens Place:
- Formula: `=ROUNDDOWN(145.78, -1)`
- Result: `140`
- This rounds the number 145.78 down to 140, removing the unit digits.
Steps to use ROUNDDOWN in Excel:
- Click on the cell where you want the result to appear.
- Type `=ROUNDDOWN(` within the selected cell or in the formula bar.
- Enter the `number` and `num_digits` separated by a comma.
- Close the parenthesis `)` and press `Enter`.
This will apply the rounding down operation and display the result in the selected cell.
Unlock Your Potential
Excel
Access
Power BI
