WorksheetFunction.DollarFr Method

Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.

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

Syntax

'Declaration
Function DollarFr ( _
    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.DollarFr(Arg1, _
    Arg2)

double DollarFr(
    Object Arg1,
    Object Arg2
)

Parameters

• Arg1
  Type: System.Object

  Decimal_dollar - is a decimal number.

• Arg2
  Type: System.Object

  Fraction - the integer to use in the denominator of a fraction.

Return Value

Type: System.Double

Remarks

If fraction is not an integer, it is truncated.

If fraction is less than 0, DollarFr returns the #NUM! error value.

If fraction is 0, DollarFr returns the #DIV/0! error value.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace