Round

Syntax

Round([Num][, Places])

Description

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

Parameter	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.

See Also

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