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