round

Rounds x to the nearest integer. If equidistant between 2 integers, the function breaks ties by rounding to the even number.

Syntax

round(x)

Parameters

x can be any of the following data types:
long, money, or double.

Examples

• round(1.4) = 1
• round(1.6) = 2
• round(1.5) = 2
• round(2.5) = 2
• round(-1.5) = -2
• round(-2.5) = -2

Related links

• Use functions in custom columns
• floor
• ceiling