Difference between revisions of "Documentation/How Tos/Calc: DOLLARDE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Example:) |
|||
Line 2: | Line 2: | ||
== DOLLARDE == | == DOLLARDE == | ||
− | Converts a fractional number representation into a decimal | + | Converts a fractional number representation of a number into a decimal number. |
=== Syntax: === | === Syntax: === |
Revision as of 12:11, 27 July 2008
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.