WorksheetFunction.DollarDe Method
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. Use DOLLARDE to convert fractional dollar numbers, such as securities prices, to decimal numbers.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function DollarDe ( _
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.DollarDe(Arg1, _
Arg2)
double DollarDe(
Object Arg1,
Object Arg2
)
Parameters
Arg1
Type: System.ObjectFractional_dollar - is a number expressed as a fraction.
Arg2
Type: System.ObjectFraction - the integer to use in the denominator of the fraction.
Return Value
Type: System.Double
Remarks
If fraction is not an integer, it is truncated.
If fraction is less than 0, DollarDe returns the #NUM! error value.
If fraction is 0, DollarDe returns the #DIV/0! error value.