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

Run the query

print c1 = ceiling(-1.1), c2 = ceiling(0), c3 = ceiling(0.9)

Output

c1	c2	c3
-1	0	1