Excel CEILING.PRECISE function

Function              CEILING.PRECISE

Description        Excel CEILING.PRECISE function returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Doesn’t matter about the sign of the number, the number is rounded up. If the number or the significance is zero, then it returns zero.

Syntax  CEILING.PRECISE(number, [significance])

Number    Mandatory. The numerical value to be rounded.

Significance    [Optional]. The multiple to which number is to be rounded.

If significance is omitted, its default value is 1.

Example:

=CEILING.PRECISE(-233.4,5)= 230

=CEILING.PRECISE(67,5)= 70