### CEILING(number, significance)

Returns the number rounded up to the nearest integer or significant figure.

 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.* If any of the arguments are not numeric, then #VALUE! is returned.* If "significance" < 0, then the absolute value is taken.* If "significance" = 0, then 0 is returned.* If "number"is positive and "significance" is negative, then #NUM! is returned.* If "number" is negative and "significance" is positive then the direction of the rounding is reversed. Examples 17 and 19.* Positive decimal numbers are rounded up to the nearest integer.* Negative decimal numbers are rounded up to the nearest integer (away from zero). Example 5.* For the Microsoft documentation refer to support.office.com

 A 1 =CEILING(1.1,1) = 2 2 =CEILING(1.5,1) = 2 3 =CEILING(1.9,1) = 2 4 =CEILING(-1.1,-1) = -2 5 =CEILING(-1.5,-1) = -2 6 =CEILING(-1.9,-1) = -2 7 =CEILING(2.5,2) = 4 8 =CEILING(-2.5,-2) = -4 9 =CEILING(8,1.5) = 9 10 =CEILING(8.26,0.05) = 8.3 11 =CEILING(0.234,0.01) = 0.24 12 =CEILING(4.2,1) = 5 13 =CEILING(4.2,-1) = #NUM! 14 =CEILING(4.2,2) = 6 15 =CEILING(4.2,-2) = #NUM! 16 =CEILING(-4.2,1) = -4 17 =CEILING(-4.2,-1) = -5 18 =CEILING(-4.2,2) = -4 19 =CEILING(-4.2,-2) = -6 20 =CEILING(4,-2) = #NUM! 21 =CEILING(-2.5,2) = -2