ISO.CEILING function

The ISO.CEILING function is one of the math and trigonometry functions. It is used to return a number that is rounded up to the nearest integer or to the nearest multiple of significance. The number is always rounded up regardless of its sign.

Syntax

ISO.CEILING(number, [significance])

The ISO.CEILING function has the following arguments:

Argument	Description
number	The number you wish to round up.
significance	The multiple of significance you wish to round up to. It is an optional parameter. If it is omitted, the default value of 1 is used. If it is set to zero, the function returns 0.

Notes

How to apply the ISO.CEILING function.

Examples

The figure below displays the result returned by the ISO.CEILING function.