DOLLARFR Function
Converts a decimal price into fractional notation, like 32nds.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A fractional price
Want to practice DOLLARFR in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
DOLLARFR is the reverse of DOLLARDE: 101.09375 becomes 101.03, meaning 101 and 3/32.
Use it to report prices in the convention traders expect.
Syntax
=DOLLARFR(decimal_dollar, fraction) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| decimal_dollar | Yes | The decimal price. |
| fraction | Yes | The denominator to use, e.g. 32. |
Examples
Example 1 — Decimals back to quotes
Convert calculated prices back into 32nds.
C2fx=DOLLARFR(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | Decimal | Fraction | Quote |
| 2 | 101.09375 | 32 | 101.03 |
| 3 | 99.5 | 32 | 99.16 |
| 4 | 1.125 | 16 | 1.02 |
99.16 means 99 and 16/32 — not 99.16 dollars.
Common mistakes
- The result looks like a normal price. It isn't — the decimals are a numerator. Never add or average DOLLARFR results.
Notes
- Related functions: DOLLARDE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.