O'Reilly logo

VBScript in a Nutshell, 2nd Edition by Ron Petrusha, Matt Childs, Paul Lomax

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 the numdecimalplaces 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 of numdecimalplaces are dropped.

    • If the digit in the position to the right of numdecimalplaces is 5 and the digit in the numdecimalplaces position is odd, the digit in the numdecimalplaces position is incremented by one.

    • If the digit in the position to the right of numdecimalplaces is 5 and the digit in the numdecimalplaces position is even, the digits to the right of numdecimalplaces 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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required