ceil
Syntax Format
ceil(x)
Overview
The ceil function helps you to round up the indicated value type. Unlike the floor function, ceil returns the smallest integer greater than or equal to x" (i.e. rounds toward positive infinity). The function may be useful in scripts where the rounded values are needed rather than the decimals.
Parameters
| Parameter | Type | Purpose |
|---|---|---|
| x | numeric or series[numeric] | The input value, taken into calculation |
Returns: series or series[integer].
Example
value1 = ceil(1.6) --equals 2
value2 = ceil(6.2) --equals 7
value3 = ceil(5) --equals 5