# Ceil

Ceil() rounds x up to the nearest multiple of step [+ offset]. The default value of offset is 0.

Compare with the floor function, which rounds input numbers down.

Syntax:

Ceil(x[, step[, offset]])

Return data type: integer

Examples and results:

* Ceil( 2.4 ): returns 3
* Ceil( 2.6 ): returns 3
* Ceil( 3.88 , 0.1 ): returns 3.9
* Ceil( 3.88 , 5 ): returns 5
* Ceil( 1.1 , 1 ): returns 2
* Ceil( 1.1 , 1 , 0.5 ): returns 1.5
* Ceil( 1.1 , 1 , -0.01 ): returns 1.99

## Learn more

* [Floor](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/GeneralNumericFunctions/floor.htm)