DOLLARDE:
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
The DOLLARDE function converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.
The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar,
you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).
Using the DOLLARDE function:
The arguments for the DOLLARDE function are:
Argument

Required?

Description

fractional dollar 
Required 
A number expressed as an integer part and a fraction part, separated by a decimal symbol. 
fraction 
Required 
The integer to use in the denominator of the fraction. 
• If fraction is not an integer, it is truncated. 
• If fraction is less than 0, DOLLARDE returns the #NUM! error value. 
• If fraction is greater than or equal to 0 and less than 1, DOLLARDE returns the #DIV/0! error value. 
The DOLLARDE function converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.