Excel like a finance pro.
← The libraryPractice · 2 questions →
Financial function
DOLLARFR
Converts a decimal price into a fractional quote, like 1.125 into 1.02 for sixteenths.
Rarely usedDifficulty 1400 · AdvancedUsage rank #343 of 520
When to use it
Converts a decimal price into a fractional quote.
The shape of it
- Syntax
=DOLLARFR(decimal_dollar, fraction)
Worked examples
Sixteenths
=DOLLARFR(1.125,16) → 1.02
2/16.
Thirty-seconds
=DOLLARFR(1.125,32) → 1.04
4/32.
Bond quote
=DOLLARFR(100.5,32) → 100.16
16/32.
Worth knowing
- The result is a number that only looks like a fraction; do not do math on it.
- DOLLARDE reverses it.
- Format with enough decimals to show the numerator.
Where it goes wrong
- #NUM! for a fraction of 0 or negative.
- Treating the result as a decimal price gives wrong totals.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.