Syntax 

Round([Num][, Places])


Group 

Math 


Description 

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


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 even 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