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.

DOLLARDE takes 2 required arguments and no optional arguments:

Syntax: DOLLARDE(fractional dollar, fraction)

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. ##### A few more things:
 • 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.

### Summary

The DOLLARDE function converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
comments powered by Disqus