DOLLARDE function
DOLLARDE(FractionalRepresentation, Denominator)
DOLLARDE(FractionalRepresentation; Denominator)
FractionalRepresentation
Number or { Number }
The fractional representation to convert.
Denominator
Number or { Number }
The denominator.
Returns
Number or { Number }
A converted decimal number.
Converts a fractional number representation of a number into a decimal number. Security prices, for example, are sometimes expressed as 2.03, meaning $2 and 3/16th of a dollar. Use DOLLARFR to perform the reverse calculation.
Example
DOLLARDE(2.03,
16)DOLLARDE(2,03;
16)
Converts $2 and 3/16th of a dollar to its decimal value, $2.1875.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.