DOLLARDE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
DOLLARDE
Converts a fractional number representation of a number into a decimal number.
Syntax:
DOLLARDE(fractionalrep; denominator)
- fractionalrep: the fractional representation. Sometimes a security price, for example, might be expressed as 2.03, meaning $2 and 3/16 of a dollar.
- denominator: the denominator - for example, 16 in the example above.
- DOLLARDE converts the fractional representation to decimal. Despite its name, it returns a number, not a currency. Its inverse is DOLLARFR.
Example:
DOLLARDE(2.03; 16)
- returns 2.1875 as a number. 2 + 3/16 equals 2.1875.
See Also
