ROUND

Syntax

ROUND (Data, Integer)

Note:

The Integer argument is optional.

Description

The ROUND function, when you use only the first argument, returns the value of Data rounded to the nearest whole number. If you use the optional second argument, the ROUND function returns the value of Data rounded to the number of decimal places that you specify with the Integer argument.

The default value for the Integer argument is zero.

Example

The following examples employ the ROUND built-in function:

• ROUND(14) returns 14.

• ROUND(14.3) returns 14.

• ROUND(14, 0) returns 14.

• ROUND(14.3, 0) returns 14.

• ROUND(14.5, 0) returns 15.

• ROUND(14.7, 0) returns 15.

• ROUND(34.56789, 4) returns 34.5679.