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) ##### Using the CEILING function:   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. ##### 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