# CEILING

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.microsoft.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