Skip to Content

CEILING

Rounds a number to the nearest integer or to the nearest multiple of significance. Replaced by CEILING.MATH.

Syntax

CEILING(number, significance)

Parameters

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

Example

=CEILING(2.5, 1)
Returns: NumberSince: Excel 2003