DOLLARFR (Decimal, Denominator) DOLLARFR (Decimal; Denominator)
Decimal
Number Number
The decimal number to convert.
Denominator
Number Number
The denominator for the fractional representation.
Returns
Number Number
A converted fractional representation.
Converts a decimal number into a fractional representation of that number. This is commonly used in bond markets, where prices are quoted in fractions such as 32nds or 64ths. Use DOLLARDE to perform the reverse calculation.
Example
DOLLARFR (5.375, 32)
DOLLARFR (5,375; 32)
Converts $5.375 to its fractional representation, 5.12, which means $5 and 12/32nds of a dollar.