Functions
CEILING.PRECISE
Round up to nearest multiple; sign of significance ignored
Try it
When to use it
When should I use CEILING.PRECISE?
Use CEILING.PRECISE when you want ceiling rounding and the sign of the significance argument should not affect the direction; it always rounds toward positive infinity.
Used in
Syntax
CEILING.PRECISE(number, [significance])Examples
=CEILING.PRECISE(-10.5,1) // => -10
=CEILING.PRECISE(96,10) // => 100
=CEILING.PRECISE(-23.25,0.1) // => -23.200000000000003