Round Function

Round([,`expression`

])`numdecimalplaces`

`expression`

Use: Required

Data Type: Numeric

Any numeric expression.

`numdecimalplaces`

Use: Optional

Data Type: Long

The number of places to include after the decimal point.

The same data type as
* expression*.

Rounds a given number to a specified number of decimal places.

can be any whole number between 0 and 16.`numdecimalplaces`

*Round*follows standard rules for rounding:If the digit in the position to the right of

is greater than 5, the digit in the`numdecimalplaces`

position is incremented by one.`numdecimalplaces`

If the digit in the position to the right of

is less than 5, the digits to the right of`numdecimalplaces`

are dropped.`numdecimalplaces`

If the digit in the position to the right of

is 5 and the digit in the`numdecimalplaces`

position is odd, the digit in the`numdecimalplaces`

position is incremented by one.`numdecimalplaces`

If the digit in the position to the right of

is 5 and the digit in the`numdecimalplaces`

position is even, the digits to the right of`numdecimalplaces`

are dropped.`numdecimalplaces`

If * expression* is a string
representation of a numeric value,

`expression`

`expression`

Start Free Trial

No credit card required