Skip to main content

Ceil

ON THIS PAGE

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:  

Examples 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

See also

 

Join the Analytics Modernization Program

Modernize by leveraging your QlikView investment to begin using Qlik Sense on the Cloud.

Want to know more?
Remove banner from view