Excel VBA Round Function
VBA Round Function: The Round function in VBA rounds a number to a specified number of decimal places and returns the number.
Syntax
Round (Number, [NumDigitsAfterDecimal])
Parameter
Number (required) –This parameter represents a numeric value one wants to round.
NumDigitsAfterDecimal (optional) – This parameter represents a positive integer stating the number of decimal places that you want to round to. By default, it is set to 0.
Return
This function returns a rounded number to the specified number of decimals.
Example 1
Sub RoundFunction_Example1() ' Rounding the number for 0 decimal places. Dim round_val As Double round_val = Round(57.777) ' The variable round_val will return 58 Cells(1, 1).Value = round_val End Sub
Output
58
Example 2
Sub RoundFunction_Example2() ' Rounding the number for 2 decimal places. Dim round_val As Double round_val = Round(57.777, 2) ' The variable round_val will return 58.78 Cells(1, 1).Value = round_val End Sub
Output
58.78
Example 3
Sub RoundFunction_Example3() ' Rounding the number for -2 decimal places. Dim round_val As Double 'for negative number digit after decimal round_val = Round(57.777, -2) ' The variable round_val will return run-time error. Cells(1, 1).Value = round_val End Sub
Output