FLOOR.PRECISE

FLOOR.PRECISE(number [,significance])

Returns the number rounded down to the nearest integer or multiple.

number	The number to be rounded down.
significance	(Optional) The multiple you want the number rounded to.

REMARKS

* FLOOR.MATH was added in Excel 2013 to replace this function.
* Negative decimal numbers are always rounded down (away from zero). The FLOOR.MATH function gives you a choice.
* For example FLOOR(-1.1,-1) = -1 but FLOOR.PRECISE(-1.1,-1) = -2.
* This function is only available for backwards compatibility and should not be used.
* This function does not appear in the Function Wizard or the Cell AutoComplete.
* There was also a CEILING.PRECISE that rounded the number up.
* This function was added in Excel 2010 to replace the FLOOR function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=FLOOR.PRECISE(1.9) = 1
2	=FLOOR.PRECISE(1.1) = 1
3	=FLOOR.PRECISE(1.1, 1) = 1
4	=FLOOR.PRECISE(3.1, 3) = 3
5	=FLOOR.PRECISE(9.1, 9) = 9
6	=FLOOR.PRECISE(15.1, 15) = 15
7	=FLOOR.PRECISE(-1.1) = -2
8	=FLOOR.PRECISE(-1.1, -1) = -2
9	=FLOOR.PRECISE(-1.1, 1) = -2
10	=FLOOR.PRECISE(-1.1, 1) = -2
11	=FLOOR.PRECISE(-1.1, 3) = -3
12	=FLOOR.PRECISE(-1.1, 3) = -3
13	=FLOOR.PRECISE(-1.1, 9) = -9
14	=FLOOR.PRECISE(-1.1, 15) = -15
15	=FLOOR.PRECISE(13, 2) = 12
16	=FLOOR.PRECISE(-13, 2) = -14
17	=FLOOR.PRECISE(8.26, 0.05) = 8.25
18	=FLOOR.PRECISE(0.234, 0.01) = 0.23
19	=FLOOR.PRECISE(NOW(), "0:20") = 8:40:00 AM
20	=FLOOR.PRECISE("") = #VALUE!

1 - What is 1.9 rounded down to a multiple of 1.
2 - What is 1.1 rounded down to a multiple of 1.
3 - What is 1.1 rounded down to a multiple of 1.
4 - What is 3.1 rounded down to a multiple of 3.
5 - What is 9.1 rounded down to a multiple of 9.
6 - What is 15.1 rounded down to a multiple of 15.
7 - What is -1.1 rounded down to a multiple of 1.
8 - What is -1.1 rounded down to a multiple of -1.
9 - What is -1.1 rounded down to a multiple of 1.
10 - What is -1.1 rounded down to a multiple of 1.
11 - What is -1.1 rounded down to a multiple of 3.
12 - What is -1.1 rounded down to a multiple of 3.
13 - What is -1.1 rounded down to a multiple of 9.
14 - What is -1.1 rounded down to a multiple of 15.
15 - What is 13 rounded down to a multiple of 2.
16 - What is -13 rounded down to a multiple of 2.
17 - What is 8.26 rounded down to a multiple of 0.05.
18 - What is 0.234 rounded down to a multiple of 0.01.
19 - What is the current time rounded down to the nearest 20 minutes.
20 - If any of the arguments are not numeric.