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).

#1)
Using the DOLLARDE function:
#2)
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.
#3)
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