round
Syntax Format
round(value)
Overview
The round function provides the closest to integer value of the given value.
You can also use:
- The
floorfunction to always round down: 2.45 → 2; 45.9 → 45. - The
ceilfunction to always round up: 2.45 → 3; 45.9 → 46.
Parameters
| Parameter | Type | Purpose |
|---|---|---|
| value | numeric or series[numeric] | Input value, taken into calculation |
Returns: integer or series[integer].
Example
value1 = round(1.6) -- equals 2
value2 = round(6.2) -- equals 6
value3 = round(5) -- equals 5