DOLLARFR

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 this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

DOLLARFR(decimal_dollar,fraction)

Decimal_dollar   is a decimal number.

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

Remarks

• If either argument is nonnumeric, DOLLARFR returns the #VALUE! error value.
• If fraction is not an integer, it is truncated.
• If fraction £ 0, DOLLARFR returns the #NUM! error value.

Examples

DOLLARFR(1.125,16) equals 1.02

DOLLARFR(1.125,8) equals 1.1