What is the syntax for DOLLARDE in Excel?

The syntax for DOLLARDE is: =DOLLARDE(fractional_dollar, fraction)

What is DOLLARDE used for?

DOLLARDE converts fractional dollar prices to decimal. Bond and stock prices are often quoted in fractions (like 99-16 meaning 99 and 16/32). DOLLARDE converts these to decimal for calculations. Essential for fixed income trading.

How do I convert bond prices quoted in 32nds?

Bond prices in 32nds: 99-16 means 99 and 16/32. Use =DOLLARDE(99.16, 32) to get 99.5. The decimal part (16) represents the numerator; the second parameter (32) is the denominator. Result: 99 + 16/32 = 99.5.

What's the difference between DOLLARDE and DOLLARFR?

DOLLARDE converts fractional to decimal (99.16 in 32nds → 99.5). DOLLARFR converts decimal to fractional (99.5 → 99.16 in 32nds). Use DOLLARDE when you have quoted prices; use DOLLARFR when you need to quote a calculated price.

Financial

DOLLARDE Function in Excel

Converts a dollar price expressed as a fraction into a decimal number.

Syntax

=DOLLARDE(fractional_dollar, fraction)

Arguments

fractional_dollar (required): Number with fraction
fraction (required): Denominator of fraction

Examples

=DOLLARDE(1.02, 16) - Convert 1 and 2/16 - Result: 1.125

DOLLARDE modeling tips

Align rate and period units (annual rate ÷ 12 for monthly models).
Use consistent cash-flow signs (outflows negative, inflows positive).
Hub: [Financial functions guide](/guides/excel-financial-functions-guide/).

Common errors

#NUM! if fraction < 0

Use cases

Bond pricing
Stock quotes
Price conversion

Frequently asked questions

What is DOLLARDE used for? DOLLARDE converts fractional dollar prices to decimal. Bond and stock prices are often quoted in fractions (like 99-16 meaning 99 and 16/32). DOLLARDE converts these to decimal for calculations. Essential for fixed income trading.
How do I convert bond prices quoted in 32nds? Bond prices in 32nds: 99-16 means 99 and 16/32. Use =DOLLARDE(99.16, 32) to get 99.5. The decimal part (16) represents the numerator; the second parameter (32) is the denominator. Result: 99 + 16/32 = 99.5.
What's the difference between DOLLARDE and DOLLARFR? DOLLARDE converts fractional to decimal (99.16 in 32nds → 99.5). DOLLARFR converts decimal to fractional (99.5 → 99.16 in 32nds). Use DOLLARDE when you have quoted prices; use DOLLARFR when you need to quote a calculated price.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.