Name
Round Function
Syntax
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.
Return Value
The same data type as
expression
.
Description
Rounds a given number to a specified number of decimal places.
Rules at a Glance
numdecimalplaces
can be any whole number between 0 and 16.Round follows standard rules for rounding:
If the digit in the position to the right of
numdecimalplaces
is greater than 5, the digit in thenumdecimalplaces
position is incremented by one.If the digit in the position to the right of
numdecimalplaces
is less than 5, the digits to the right ofnumdecimalplaces
are dropped.If the digit in the position to the right of
numdecimalplaces
is 5 and the digit in thenumdecimalplaces
position is odd, the digit in thenumdecimalplaces
position is incremented by one.If the digit in the position to the right of
numdecimalplaces
is 5 and the digit in thenumdecimalplaces
position is even, the digits to the right ofnumdecimalplaces
are dropped.
Programming Tips and Gotchas
If expression
is a string
representation of a numeric value, Round
converts it to a numeric value before rounding. However, if
expression
isn’t a string representation
of a number, Round generates runtime error 13,
“Type mismatch.” The IsNumeric function insures
that expression
is a proper numeric
representation before calling Round.
See Also
Get VBScript in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.