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

No credit card required

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.