Share via


WorksheetFunction.MRound Method

Excel Developer Reference

Returns a number rounded to the desired multiple.

Syntax

expression.MRound(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data Type Description
Arg1 Required Variant Number - the value to round.
Arg2 Required Variant Multiple - the multiple to which you want to round number.

Return Value
Double

Remarks

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.

See Also