Skip to main content

CEILING

The CEILING function rounds a number up to the nearest multiple of significance.

Syntax​

=CEILING(number, significance)

Parameters​

  • number: The number to round
  • significance: The multiple to round to

Examples​

=CEILING(4.2, 1) // Returns 5
=CEILING(4.2, 0.5) // Returns 4.5
=CEILING(-4.2, 1) // Returns -4