CEILING.PRECISE function

The CEILING.PRECISE 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

CEILING.PRECISE(number, [significance])

The CEILING.PRECISE 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 CEILING.PRECISE function.

Examples

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