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 closest to the negative infinity integer value, that is not less than the x value you indicated. 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