Round Function

Syntax

Round([Num][, Places])

Group

Math

Description

Return the number rounded to the specified number of decimal places.

Parameters

Parameters Description
Num Round this numeric value. If this value is Null then Null is returned.
Places Round to this number of decimal places. If this is omitted then round to the nearest integer value.

Example


Sub Main
    Debug.Print Round(.5)       ' 0
    Debug.Print Round(.500001)  ' 1
    Debug.Print Round(1.499999) ' 1
    Debug.Print Round(1.5)      ' 2
    Debug.Print Round(11.11)    ' 11
    Debug.Print Round(11.11,1)  ' 11.1
End Sub