All versions
Financial
The Excel DOLLARFR function converts a decimal price to fractional notation (like bond 32nds).
Quick answer:
=DOLLARFR(1.0625, 32) // 1.02
Syntax
=DOLLARFR(decimal_dollar, fraction)
| Argument | Description | |
|---|---|---|
decimal_dollar | Required | A price as a decimal number. |
fraction | Required | The denominator to express it in (e.g. 32). |
How to use it
DOLLARFR converts a decimal price to fractional notation (like bond 32nds).
=DOLLARFR(1.0625, 32) // 1.0625 = 1.02 (1 and 2/32)
Try it: interactive demo
Live demo
This is the formula pattern DOLLARFR uses — copy it into Excel with your own numbers.
Result: computed in Excel
Practice workbook
Download the free DOLLARFR 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
What does the result mean?
The integer part is dollars; the decimals encode the numerator over your chosen denominator.
DOLLARFR vs DOLLARDE?
Inverses: DOLLARFR goes decimal→fraction; DOLLARDE goes the other way.
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