Documentation/How Tos/Calc: DOLLARDE function

From Apache OpenOffice Wiki
Jump to: navigation, search


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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DOLLARDE_function&oldid=243614"
Views
Personal tools
Navigation
Tools