Skip to main content
Previous section   Next section

Round

Returns a number rounded to a specified number of decimal places.

Synopsis

Round(expression[,numdecimalplaces])

Arguments

expression The numeric expression being rounded.
numdecimalplaces Optional — Number indicating how many places to the right of the decimal are included in the rounding. If omitted, expression rounded to an integer is returned.

Description

The Round function always rounds the number 5 up. Leading and trailing zeros are deleted.

Round returns expression rounded to:

  • An integer if the numdecimalplaces argument is omitted, or specified as 0, the empty string (""), or a negative number.

  • The specified number of decimal places (excluding trailing zeros). A fractional value for numdecimalplaces is truncated to an integer.

  • The actual number of decimal places (excluding trailing zeros) if the numdecimalplaces argument is greater than or equal to the actual number of decimal places

Examples

The following example uses the Round function to round a number to three decimal places:

Dim MyVar, pi
pi = 3.14159
MyVar = Round(pi,3) ' MyVar contains 3.142.
Println MyVar
Copy code to clipboard

See Also