CEILING(number, significance)

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:

Other mathematical functions