Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

WorksheetFunction.DollarFr Method

Office 2007
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.

Syntax

expression.DollarFr(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredVariantDecimal_dollar - is a decimal number.
Arg2RequiredVariantFraction - the integer to use in the denominator of a fraction.

Return Value
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.



Community Additions

Show: