Name

ceil — Rounds a number up to the next nearest mathematical integer value.

Syntax

ceil(number)
                

The CEIL function has the following arguments:

number

The number or integer of which you want the ceiling value

Description

The ceil function returns the smallest (closest to negative infinity) double value that is greater than or equal to the argument and is equal to a mathematical integer. The function will return a double precision number.

Examples

Formula

Description

Result

ceil(0.9)

Round up 0.9 to the nearest integer

1.0

ceil(-5.6)Round up -5.6 to the nearest integer-5.0
ceil(10.0)Round up 10 to the closest integer10.0