Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
1 out of 2 rated this helpful - Rate this topic

WorksheetFunction.MRound Method

Office 2007
Returns a number rounded to the desired multiple.

Syntax

expression.MRound(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantNumber - the value to round.
Arg2RequiredVariantMultiple - 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.




Community Additions

Show:
© 2014 Microsoft. All rights reserved.