CEILING

CEILING(number, significance)

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

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.
* Negative decimal numbers are always rounded up (away from zero). The CEILING.MATH function gives you a choice.
* If "significance" < 0, then the absolute value is not taken.
* This function is only available for backwards compatibility and should not be used.
* There was also a FLOOR function that rounded the number down.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=CEILING(1.9, 1) = 2
2	=CEILING(1.1, 1) = 2
3	=CEILING(1.1, -1) = #NUM!
4	=CEILING(3.1, 3) = 6
5	=CEILING(9.1, 9) = 18
6	=CEILING(15.1, 15) = 30
7	=CEILING(-1.1, 1) = -1
8	=CEILING(-1.1, 1) = -1
9	=CEILING(-1.1, 1) = -1
10	=CEILING(-1.1, 1) = -1
11	=CEILING(-1.1, 3) = 0
12	=CEILING(-1.1, 3) = 0
13	=CEILING(-1.1, 9) = 0
14	=CEILING(-1.1, 15) = 0
15	=CEILING(13, 2) = 14
16	=CEILING(-13, 2) = -12
17	=CEILING(15, 0) = 0
18	=CEILING(-15, 0) = 0
19	=CEILING(NOW(), "0:20") = 7:00:00 AM
20	=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 1.1 rounded up to a multiple of -1. When "multiple" < 0, the absolute value is not taken.
4 - What is 3.1 rounded up to a multiple of 3.
5 - What is 9.1 rounded up to a multiple of 9.
6 - What is 15.1 rounded up to a multiple of 15.
7 - What is -1.1 rounded up to a multiple of 1.
8 - What is -1.1 rounded up to a multiple of 1.
9 - What is -1.1 rounded up to a multiple of 1.
10 - What is -1.1 rounded up to a multiple of 1. Always rounded up.
11 - What is -1.1 rounded up to a multiple of 3.
12 - What is -1.1 rounded down to a multiple of 3. Always rounded up.
13 - What is -1.1 rounded down to a multiple of 9. Always rounded up.
14 - What is -1.1 rounded down to a multiple of 15. Always rounded up.
15 - What is 13 rounded up to a multiple of 2.
16 - What is -13 rounded up to a multiple of 2.
17 - What is 8.26 rounded up to a multiple of 0.05.
18 - What is 0.234 rounded up to a multiple of 0.01.
19 - What is the current time rounded up to the nearest 20 minutes.
20 - If any of the arguments are not numeric.