Functions
ISO.CEILING
ISO standard ceiling; identical to CEILING.PRECISE
Try it
When to use it
When should I use ISO.CEILING instead of CEILING?
Use ISO.CEILING when you want the sign of the significance argument to be ignored — it always rounds toward positive infinity, matching the ISO standard behaviour.
Syntax
ISO.CEILING(number, [significance])Examples
=ISO.CEILING(-10.5,1) // => -10
=ISO.CEILING(96,10) // => 100
=ISO.CEILING(-23.25,0.1) // => -23.200000000000003