Round Function

Syntax:

Round([Num][, Places])

Group:

Math

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.

 

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