WorksheetFunction.MRound Method (Excel)
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.