ROUNDDOWN

Description

Use this function to round a number down towards zero. Supported in Chains.

ROUNDDOWN is useful for controlling the precision of numerical data in calculations and display.

ROUNDDOWN(number, num_digits)

This function accepts the following arguments:

Name	Required	Description	Valid input
`number`	Yes	The number you want to round down.	A number, a reference to a cell containing a number, or a formula which results in either of these.
`num_digits`	Yes	The number of digits to which you want to round the number down.	An integer (positive, negative, or zero), a reference to a cell containing an integer, or a formula which results in either of these. A positive value rounds to the right of the decimal point; a negative value rounds to the left of the decimal point.

Use case	Formula	Explanation and Result
Round a value down to a set number of decimal places, so it's never overstated.	`=ROUNDDOWN(A1, 2)`	Rounds 3.14159 down to 2 decimal places rather than applying standard rounding rules. Result: 3.14
Round a large number down to the nearest hundred.	`=ROUNDDOWN(B1, -2)`	A negative `num_digits` rounds down the digits to the left of the decimal point, dropping 1234.5678 to the nearest hundred below it. Result: 1200
Round a negative value down to a set number of decimal places, keeping it closer to zero.	`=ROUNDDOWN(A2, 1)`	This function always rounds toward zero, so −2.9876 becomes less negative rather than more. Result: −2.9
Round a very small value down to a set number of decimal places, so it's never overstated.	`=ROUNDDOWN(B2, 3)`	Rounds 0.0005 down at the 3rd decimal place, discarding the remainder rather than rounding it up. Result: 0.000
Round a value down to the nearest whole number, even if it's roughly halfway between two integers.	`=ROUNDDOWN(A3, 0)`	Rounds 10.5 down to the nearest integer instead of up. Result: 10
Attempt to round a text value instead of a number.	`=ROUNDDOWN(A4, 0)`	This function can't operate on text, so it returns an error instead of a rounded value. Result: #VALUE!

If ROUNDDOWN is applied to text, it will result in a #VALUE! error.
ROUNDDOWN is different from formatting a cell to display a certain number of decimal places, as it actually changes the value stored in the cell by removing all digits to the right of the last digit rounded.
ROUNDDOWN differs from the ROUND and ROUNDUP functions in the following ways:
- ROUNDDOWN always rounds towards zero, regardless of whether the number is positive or negative.
  - If num_digitsis greater than 0, ROUNDDOWN rounds down to the specified number of decimal places.
  - If num_digitsis 0, ROUNDDOWN rounds down to the nearest integer.
  - Ifnum_digitsis negative, ROUNDDOWN rounds down the digits to the left of the decimal point
- ROUNDUP always rounds away from zero.
- ROUND follows standard rounding rules: if the digit to the right of the rounding position is 5 or greater, it rounds up; otherwise, it rounds down.
- Applying ROUND to a positive number will increase it in a positive direction, applying ROUND to a negative number will increase it in a negative direction.

Use ROUNDDOWN when you need to ensure that numbers are always rounded down, regardless of their value.
For displaying numbers with a certain number of decimal places without changing the underlying value, use cell formatting instead of ROUNDDOWN.
You can combine ROUNDDOWN with other functions such as SUM or AVERAGE to control the precision of complex calculations.
Be aware of potential rounding errors in financial calculations where high precision is required.
Consider using the other rounding functions (linked in Related functions) if you need to round numbers in a different manner.