ceiling()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates the smallest integer greater than, or equal to, the specified numeric expression.
Syntax
ceiling(number)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| number | int, long, or real | ✔️ | The value to round up. |
Returns
The smallest integer greater than, or equal to, the specified numeric expression.
Examples
print c1 = ceiling(-1.1), c2 = ceiling(0), c3 = ceiling(0.9)
Output
| c1 | c2 | c3 |
|---|---|---|
| -1 | 0 | 1 |