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.
Fractional_dollar is a number expressed as a fraction.
Fraction is the integer to use in the denominator of the fraction.
- 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.
DOLLARDE(1.02,16) equals 1.125
DOLLARDE(1.1,8) equals 1.125