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