ECMA.CEILING

ECMA.CEILING(number, significance)

Returns the number rounded up to the nearest multiple of significance (renamed).

number	The number to be rounded up.
significance	The multiple you want the number rounded to.

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 ISO.CEILING before the final 2010 release.
* This function does not appear in the Function Wizard or the Cell AutoComplete.

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