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, Arg2Arg1 - Number - the value to round
Arg2 - Multiple - the multiple to which you want to round number