DOLLARDE

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.

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

DOLLARDE(fractional_dollar,fraction)

Fractional_dollar   is a number expressed as a fraction.

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

Remarks

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

Examples

DOLLARDE(1.02,16) equals 1.125

DOLLARDE(1.1,8) equals 1.125