Round down to given number of digits
=ROUNDDOWN(number, num_digits)| Parameter | Description |
|---|---|
number |
The number to round down. |
num_digits |
The place at which number should be rounded. |
The ROUNDDOWN function rounds numbers down. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN rounds all numbers do
=ROUNDDOWN(3.999,0) // returns 3We can get the same result with the ROUNDDOWN function like this:
=ROUNDDOWN(2.786,0) // returns 2
=ROUNDDOWN(2.786,1) // returns 2.7
=ROUNDDOWN(2.786,2) // returns 2.78To round down values to the right of the decimal point, use a positive number for num_digits:
=ROUNDDOWN(A1,1) // Round down to nearest tenth (0.1)
=ROUNDDOWN(A1,2) // Round down to nearest hundredth (0.01)
=ROUNDDOWN(A1,3) // Round down to nearest thousandth (0.001)
=ROUNDDOWN(A1,4) // Round down to nearest ten-thousandth (0.0001)To round down values to the left of the decimal point, use zero or a negative number for digits:
=ROUNDDOWN(A1,0) // Round down to nearest 1
=ROUNDDOWN(A1,-1) // Round down to nearest 10
=ROUNDDOWN(A1,-2) // Round down to nearest 100
=ROUNDDOWN(A1,-3) // Round down to nearest 1000
=ROUNDDOWN(A1,-4) // Round down to nearest 10000Excel's ROUNDDOWN function always rounds numbers down towards zero. You can see this behavior in the examples below, where the number to round is give
=ROUNDDOWN(-2.786,0) // returns -2
=ROUNDDOWN(-2.786,1) // returns -2.7
=ROUNDDOWN(-2.786,2) // returns -2.78Other operations and functions can be nested inside ROUNDDOWN. For example, to round down the result of A1 divided by B1, you can use a formula like t
=ROUNDDOWN(A1/B1,0) // round down result to nearest integer