ROUNDDOWN

ROUNDDOWN(number, num_digits)

Returns the number rounded down to the nearest integer.

number	The number you want to round down (towards zero).
num_digits	The number of digits you want to round the number down 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 ROUNDUP function to round up to the nearest integer.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ROUNDDOWN(123.456,-4) = 0
2	=ROUNDDOWN(123.456,-3) = 0
3	=ROUNDDOWN(123.456,-2) = 100
4	=ROUNDDOWN(123.456,-1) = 120
5	=ROUNDDOWN(123.456,0) = 123
6	=ROUNDDOWN(123.456,1) = 123
7	=ROUNDDOWN(123.456,2) = 123
8	=ROUNDDOWN(123.456,3) = 123
9	=ROUNDDOWN(123.456,4) = 123
10	=ROUNDDOWN(56.78,-4) = 0
11	=ROUNDDOWN(56.78,-3) = 0
12	=ROUNDDOWN(56.78,-2) = 0
13	=ROUNDDOWN(56.78,-1) = 50
14	=ROUNDDOWN(56.78,0) = 56
15	=ROUNDDOWN(56.78,1) = 57
16	=ROUNDDOWN(56.78,2) = 57
17	=ROUNDDOWN(56.78,3) = 57
18	=ROUNDDOWN(56.78,4) = 57