round

Syntax Format

round(value)

Overview

The round function returns the closest integer value.

You can also use:

• The floor function to always round down: 2.45 → 2; 45.9 → 45.
• The ceil function 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