CEILING.PRECISE

CEILING.PRECISE(number [,significance])

Returns the number rounded to the nearest integer or multiple (renamed).

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

REMARKS

* CEILING.MATH was added in Excel 2013 to replace this function.
* 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.
* Positive decimal numbers with a positive significance are rounded up.
* Positive decimal numbers with a negative significance are rounded up.
* Negative decimal numbers with a positive significance are rounded up.
* Negative decimal numbers with a negative significance are rounded down.
* If "significance" is left blank, then 1 is used.
* If "significance" = 0 and "number" = 0, then zero is returned.
* If "significance" = 0 and "number" <> 0, then #DIV/0! is returned.
* There was also a FLOOR.PRECISE that can round down positive numbers.
* This function was added in Excel 2010 to replace the CEILING function.
* This function was added to replace the ISO.CEILING and ECMA.CEILING functions that were introduced during Excel 2010 beta testing.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CEILING.PRECISE(15, 50) = 50
2	=CEILING.PRECISE(0.9) = 1
3	=CEILING.PRECISE(1.1) = 2
4	=CEILING.PRECISE(1.5) = 2
5	=CEILING.PRECISE(-1.5) = -1
6	=CEILING.PRECISE(1.1, 3) = 3
7	=CEILING.PRECISE(3.1, 3) = 6
8	=CEILING.PRECISE(3.1, -3) = 6
9	=CEILING.PRECISE(-1.99, - 1) = -1
10	=CEILING.PRECISE(-1.99, 1) = -1
11	=CEILING.PRECISE(-1.99, 1) = -1
12	=CEILING.PRECISE(8.26, 0.05) = 8.30
13	=CEILING.PRECISE(0.234, 0.01) = 0.24
14	=CEILING.PRECISE(NOW(), "0:20") = 3:40:00 PM
15	=CEILING.PRECISE("text", 1) = #VALUE!
16	=CEILING.PRECISE(15, 0) = 0

1 - What is 15 rounded up to a multiple of 50.
2 - What is 0.9 rounded up to a multiple of 1.
3 - What is 1.1 rounded up to a multiple of 1.
4 - What is 1.5 rounded up to a multiple of 1.
5 - What is -1.5 rounded up to a multiple of 1.
6 - What is 1.1 rounded up to a multiple of 3.
7 - What is 3.1 rounded up to a multiple of 3.
8 - What is 3.1 rounded up to a multiple of -3. The minus sign is ignored, so this is the same as a multiple of plus 3.
9 - What is -1.99 rounded up to a multiple of -1. The minus sign is ignored, so this is the same as a multiple of plus 1.
10 - What is -1.99 rounded up to a multiple of 1.
11 - What is -1.99 rounded up to a multiple of 1.
12 - What is 8.26 rounded up to a multiple of 0.05.
13 - What is 0.234 rounded up to a multiple of 0.01.
14 - What is the current time rounded up to the nearest 20 minutes.
15 - If any of the arguments are not numeric.
16 - If significance is zero.