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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for