ROUNDDOWN

ROUNDDOWN(number, num_digits)

Returns the number rounded towards zero to a certain number of decimal places.

number	The number you want to round (towards zero).
num_digits	The number of decimal places or digits: (= 0) no decimal places (> 0) the number of decimal places (< 0) the number of digits to the left of the decimal point

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive numbers are rounded down (towards zero).
* Negative numbers are rounded up (towards zero).
* If "number" is not numeric, then #VALUE! is returned.
* If "num_digits" = 2, the number will be rounded to the nearest 0.01.
* If "num_digits" = 1, the number will be rounded to the nearest 0.1.
* If "num_digits" = 0, the number will be rounded to the nearest integer.
* If "num_digits" = -1, the number will be rounded to the nearest 10.
* If "num_digits" = -2, the number will be rounded to the nearest 100.
* If "num_digits" is not numeric, then #VALUE! is returned.
* You can use the ROUND function to round to a certain number of decimal places.
* You can use the ROUNDUP function to round away from zero to a certain number of decimal places.
* You can use the MROUND function to round to a certain multiple.
* You can use the CEILING.MATH function to round up (by default) to the nearest integer or multiple.
* You can use the FLOOR.MATH function to round down (by default) to the nearest integer or multiple.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the EVEN function to return the number rounded to the nearest even integer.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* You can use the TRUNC function to round towards zero and truncated to a certain number of decimal places or digits.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ROUNDDOWN(12.344, 2) = 12.34
2	=ROUNDDOWN(12.345, 2) = 12.34
3	=ROUNDDOWN(12.345, 1) = 12.3
4	=ROUNDDOWN(12.345, 0) = 12
5	=ROUNDDOWN(0.9, 0) = 0
6	=ROUNDDOWN(1.1, 0) = 1
7	=ROUNDDOWN(1.5, 0) = 1
8	=ROUNDDOWN(-1.5, 0) = -1
9	=ROUNDDOWN(1234, 3) = 1234
10	=ROUNDDOWN(1234, -1) = 1230
11	=ROUNDDOWN(1234, -3) = 1000
12	=ROUNDDOWN(1234.567, 1) = 1234.5
13	=ROUNDDOWN(1234.567, -1) = 1230
14	=ROUNDDOWN(1234, -9) = 0
15	=ROUNDDOWN("", 0) = #VALUE!
16	=ROUNDDOWN(1.1, "") = #VALUE!

1 - What is 12.344 rounded down to 2 decimal places.
2 - What is 12.345 rounded down to 2 decimal places.
3 - What is 12.345 rounded down to 1 decimal place.
4 - What is 12.345 rounded down to 0 decimal places.
5 - What is 0.9 rounded down to 0 decimal places.
6 - What is 1.1 rounded down to 0 decimal places.
7 - What is 1.5 rounded down to 0 decimal places.
8 - What is -1.5 rounded up to 0 decimal places.
9 - What is 1234 rounded down to 3 decimal places.
10 - What is 1234 rounded down to -1 digits.
11 - What is 1234 rounded down to -3 digits.
12 - What is 1234.567 rounded down to 1 decimal place.
13 - What is 1234.567 rounded down to -1 digits.
14 - What is 1234 rounded down to -9 digits. There are only 4 digits on the left of the decimal place.
15 - When number is not numeric.
16 - When num_digits is not numeric.