ISO.CEILING

ISO.CEILING(number [,significance])

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

number	The value 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.
* If "significance" = 0, then zero is returned.
* This function was introduced in the Excel 2010 beta but was renamed to CEILING.PRECISE before the final 2010 release.
* This function does not appear in the Function Wizard or the Cell AutoComplete.
* For the Microsoft documentation refer to support.microsoft.com

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

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