Ceil function

Returns the smallest integer greater than or equal to the numeric value in each cell of a column. For example, if the value is 2.21, CEIL returns 3. If the value is 5.88, CEIL returns 6. Likewise, if the value is -5.15, CEIL returns -5.

Namespaces

• math

Input

Non-decimal numeric values

Output

Double values

Syntax

set-column :column math:ceil(column)

Example

Returns the smallest integer greater than or equal to the numeric value in each cell in the test column.

set-column :test math:ceil(test)