All versions
Financial
The Excel DOLLARDE function converts a price expressed in fractions (like bond 32nds) to a decimal number.
Quick answer:
=DOLLARDE(1.02, 32) // 1.0625
Syntax
=DOLLARDE(fractional_dollar, fraction)
| Argument | Description | |
|---|---|---|
fractional_dollar | Required | A price in fractional notation (e.g. 1.02 = 1 and 2/32). |
fraction | Required | The denominator (e.g. 32 for 32nds). |
How to use it
DOLLARDE converts a price expressed in fractions (like bond 32nds) to a decimal number.
=DOLLARDE(1.02, 32) // 1 and 2/32 = 1.0625
Try it: interactive demo
Live demo
This is the formula pattern DOLLARDE uses — copy it into Excel with your own numbers.
Result: computed in Excel
Practice workbook
Download the free DOLLARDE practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.
Frequently asked questions
Why do bond prices use fractions?
US Treasuries quote in 32nds; DOLLARDE converts those to decimals for math.
DOLLARDE vs DOLLARFR?
Inverses: DOLLARDE goes fraction→decimal; DOLLARFR goes decimal→fraction.
Which Excel versions support it?
All modern versions.
Why might it return #NUM! or #VALUE!?
Out-of-range arguments (e.g. negative rate or settlement after maturity) give #NUM!; non-numeric inputs give #VALUE!.
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class