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

ArgumentRequired?What it does
decimal_dollarYesThe decimal price.
fractionYesThe denominator to use, e.g. 32.

Examples

Example 1 — Decimals back to quotes

Convert calculated prices back into 32nds.

C2fx=DOLLARFR(A2,B2)
ABC
1DecimalFractionQuote
2101.0937532101.03
399.53299.16
41.125161.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

Kyle Stott

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.