Method

Round


Description

Returns the passed value rounded to the nearest whole number.

Usage

result = Round(value)

Part

Type

Description

result

Double

The rounded value. Although result is typed as a Double, it actually contains an integer value.

value

Double

The value you want to round.

Notes

The result of this function is a Double, but it will always contain a whole number.

The method used to Round is chosen by the operating system and the results may vary from platform to platform when the number to be rounded is exactly halfway between two whole numbers.

Sample code

This example uses the Round function to return a rounded number

Var d As Double
d = Round(1.499) ' returns 1
d = Round(1.500) ' returns 2

Compatibility

All project types on all supported operating systems.

See also

Ceiling, Floor functions.