ROUNDDOWN

ROUNDDOWN(number, num_digits)

Returns the number rounded down to a specified number of digits.

number	The number you want to round down (towards zero).
num_digits	The number of decimal places you want to round the number to.

REMARKS

* This function is identical to the ROUND function, except that it always rounds a number down.
* If "num_digits" > 0, then "number" is rounded down to the specified number of decimal places.
* If "num_digits" = 0 then "number is rounded down to the nearest integer.
* If "num_digits" < 0, then "number" is rounded down to the left of the decimal point.
* You can use the ROUND function to round to a specified number of digits.
* You can use the ROUNDUP function to round up to a specified number of digits.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the MROUND function to round to a desired multiple.
* You can use the EVEN function to round up to the nearest even integer.
* You can use the ODD function to round up to the nearest odd integer.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=ROUNDDOWN(123.456, 4) = 123.4560
2	=ROUNDDOWN(123.456, 3) = 123.456
3	=ROUNDDOWN(123.456, 2) = 123.45
4	=ROUNDDOWN(123.456, 1) = 123.40
5	=ROUNDDOWN(123.456, 0) = 123
6	=ROUNDDOWN(123.456, -1) = 120
7	=ROUNDDOWN(123.456, -2) = 100
8	=ROUNDDOWN(123.456, -3) = 0
9	=ROUNDDOWN(123.456, -4) = 0