Functions
CEILING.MATH
Round up to nearest multiple; handles negative numbers via mode
Try it
When to use it
When should I use CEILING.MATH instead of CEILING?
Use CEILING.MATH when you need control over how negative numbers are rounded; the mode argument lets you round toward or away from zero.
Used in
Syntax
CEILING.MATH(number, [significance], [mode])Examples
=CEILING.MATH(11.2) // => 12
=CEILING.MATH(-8.8) // => -8
=CEILING.MATH(7.7,0.2) // => 7.800000000000001