WorksheetFunction.MRound (Excel)

Returns a number rounded to the desired multiple.

MRound rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

MRound (Arg1, Arg2)


Dim dblMRound As Double
dblMRound = WorksheetFunction.MRound(Arg1:=, Arg2:=)

Arguments

Arg1, Arg2

Arg1 - Number - the value to round

Arg2 - Multiple - the multiple to which you want to round number