Round Function |
Syntax:
Group:
Description:
Returns the number rounded to the specified number of decimal places.
Parameters:
Parameter |
Description |
Round this numeric value. If this value is Null then Null is returned. |
|
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
EndSub