ceil
The ceil function rounds up an input numeric expression’s value to the nearest matching integer.
Alias: ceiling (ceiling and ceil are synonyms).
Syntax
ceil(number)
Arguments
| Name | Type | Required | Description |
|---|---|---|---|
| number | int, long, or real | Yes | The value to round up. |
Results
The smallest integer equal to, or greater than, the value of the specified numeric expression.
Examples
This example returns 100:
print num = 99.01
| extend newField = ceil( num )