WorksheetFunction.MRound Method

Returns a number rounded to the desired multiple.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function MRound ( _
    Arg1 As Object, _
    Arg2 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As Double

returnValue = instance.MRound(Arg1, Arg2)
double MRound(
    Object Arg1,
    Object Arg2
)

Parameters

  • Arg2
    Type: System.Object

    Multiple - the multiple to which you want to round number.

Return Value

Type: System.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

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace