Excel functions / Financial

DOLLARDE function

Turns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.

Syntax

=DOLLARDE(fractional_dollar, fraction)

Arguments

When to use it

DOLLARDE turns a price quoted with a fraction, as bonds and some commodities are, into an ordinary decimal. 1.02 in sixteenths means 1 and 2/16, which is 1.125.

Examples

  1. A price in sixteenths

    ABC
    1Quoted
    21.021.125

    In C2: =DOLLARDE(A2, 16) → 1.125

    Try this example

  2. A price in thirty-seconds

    ABC
    1Quoted
    21.11.3125

    In C2: =DOLLARDE(A2, 32) → 1.3125

    Try this example

Common mistakes

DOLLARDE 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 DOLLARDE in the playground

Related functions