Article updated on February 28, 2018

The CEILING function rounds a number up to it's nearest multiple.

The number is rounded down if both the number and multiple is negative. The number is rounded up if the number is negative and multiple is positive.

Formula in cell B3:


Excel Function Syntax

CEILING(number, significance)


number Required. The value you want to round.
significance Required. The multiple to which you want to round.