Functions
DOLLARFR
Convert decimal dollar to fractional
Try it
When to use it
When should I use DOLLARFR?
Use DOLLARFR to convert a decimal bond price back into fractional notation (e.g., 32nds) for display or reporting in markets that quote prices that way.
Used in
Syntax
DOLLARFR(decimal_dollar, fraction)Examples
=DOLLARFR(100.125,32) // => 100.04
=DOLLARFR(100.125,8) // => 100.1