Difference between revisions of "Documentation/How Tos/Calc: DOLLARDE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→Example:) |
||
Line 13: | Line 13: | ||
=== Example: === | === Example: === | ||
<tt>'''DOLLARDE(2.03; 16)'''</tt> | <tt>'''DOLLARDE(2.03; 16)'''</tt> | ||
− | : returns <tt>'''2. | + | : returns <tt>'''2.1875'''</tt> as a number. <tt>'''2'''</tt> + <tt>'''3/16'''</tt> equals <tt>'''2.1875'''</tt>. |
=== See also: === | === See also: === |
Revision as of 05:59, 15 July 2008
DOLLARDE
Converts a fractional number representation into a decimal representation.
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.