CEILING.MATH function
Summary
Rounds a number up, to the nearest integer or to the nearest multiple of significance
Syntax
CEILING.MATH(number, [significance], [mode])
• number Required. (must be between -2.229E-308.and 9.99E+307.)
• significance Optional. This is the number of significant digits after the decimal point to which number is to be rounded.
• mode Optional. This controls whether negative numbers are rounded toward or away from zero.
• significance Optional. This is the number of significant digits after the decimal point to which number is to be rounded.
• mode Optional. This controls whether negative numbers are rounded toward or away from zero.
Example
=CEILING.MATH(24.3,5)
=CEILING.MATH(6.7)
=CEILING.MATH(-8.1,2)
=CEILING.MATH(-5.5,2,-1)
=CEILING.MATH(6.7)
=CEILING.MATH(-8.1,2)
=CEILING.MATH(-5.5,2,-1)