Name

round — Returns the closest integer to the argument.

Syntax

round(number)
              

The ROUND function has the following argument:

number

The number to be rounded to the closest integer.

Description

Returns the closest integer to the argument, with ties rounding to positive infinity.

Examples

Formula

Description

Result

round(0.9)

Round 0.9 to the closest integer.

1

round(1.1)

Round 0.9 to the closest integer.

1

round(1.5)

Round 1.5 to the closest integer.

2