Round

This function rounds a number to a specified number of decimal places.

Syntax

Round(expression,[numdecimalplaces])

Parameters

expression

Required. Numeric expression being rounded.

numdecimalplaces

Optional. Number that indicates how many places to the right of the decimal are included in the rounding. If omitted, Round returns integers.

Return Values

Returns a number.

Remarks

In contrast to the Int and Fix functions, which remove the fractional part of number and return the resulting integer value, you can use Round to specify that a certain number of decimal places will remain in the rounded number.