### CEILING.PRECISE(number [,significance])

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

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

#### Remarks

 * This function does not appear in the Function Wizard or the Cell AutoComplete.* This function is only available for backwards compatibility and should never be used.* CEILING.MATH was added in Excel 2013 to replace this function.* This function was added in Excel 2010 to replace the CEILING function.* The number is always rounded up.* Alternative formula is = INT(-number/ ABS(significance) )*ABS(significance)* For the Microsoft documentation refer to support.office.com

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