Excel functions / Financial

DOLLARFR function

Turns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.

Syntax

=DOLLARFR(decimal_dollar, fraction)

Arguments

When to use it

DOLLARFR turns a decimal price into the fractional notation bond prices use: 1.125 in sixteenths is written 1.02.

Examples

  1. In sixteenths

    ABC
    1Price
    21.1251.02

    In C2: =DOLLARFR(A2, 16) → 1.02

    Try this example

Common mistakes

DOLLARFR in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DOLLARFR in the playground

Related functions