The CEILING function rounds a number to the nearest integer or to the nearest multiple of significance.

CEILING takes 2 required arguments and no optional arguments:

Syntax: CEILING(number, significance)

#1)
Using the CEILING function:
#2)
The arguments for the CEILING function are:
Argument Required? Description
number Required The value you want to round.
significance Required The multiple to which you want to round.
#3)
A few more things:
If either argument is nonnumeric, CEILING returns the #VALUE! error value.
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
If number is negative, and significance is negative, the value is rounded down, away from zero.
If number is negative, and significance is positive, the value is rounded up towards zero.

Summary

The CEILING function a number to the nearest integer or to the nearest multiple of significance.
comments powered by Disqus