Article updated on March 28, 2018

The CEILING function rounds a number up to its 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.