Round Function
Syntax
Round([Num][, Places])
Group
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