WorksheetFunction.DollarFr (Excel)

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.

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.

DollarFr (Arg1, Arg2)

Dim dblDollarFr As Double
dblDollarFr = WorksheetFunction.DollarFr(Arg1:=, Arg2:=)

Arguments

Arg1 - Decimal_dollar - a decimal number

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