CEILING(number,significance) rounds to the nearest integer or to the nearest multiple of significance : CEILING « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =CEILING(2.5, 1)
Input the formula: =CEILING(2.5, 1)
20.9.CEILING
20.9.1.CEILING(number,significance) rounds to the nearest integer or to the nearest multiple of significanceCEILING(number,significance) rounds to the nearest integer or to the nearest multiple of significance
20.9.2.=CEILING(0.234123, 0.01)=CEILING(0.234123, 0.01)