The CEILING function rounds a number upwards to the nearest multiple of significance.
Examples:
CEILING(3.657, 1) returns 4 (upwards to nearest whole number)
CEILING (4.5, 2) returns 6 (nearest number upwards divisible by 2)
Note that the sign of both parameters must be the same, so CEILING (-4.5, 2) returns #VALUE while CEILING (-4.5, -2) returns -6.
CEILING is complemented by FLOOR(number, significance)
See also: