DOLLARDE Function

Converts a fractional price, like a bond quote in 32nds, into a decimal.

Category

Financial

Available in

All versions, Microsoft 365

Returns

A decimal price

Want to practice DOLLARDE 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

US Treasury bonds are quoted in fractions: 101-03 means 101 and 3/32. DOLLARDE turns that notation — typed as 101.03 — into the decimal 101.09375.

The digits after the point are the numerator; fraction is the denominator.

Syntax

=DOLLARDE(fractional_dollar, fraction) Explain

Arguments

ArgumentRequired?What it does
fractional_dollarYesThe price with the numerator after the decimal point (101.03 = 101 3/32).
fractionYesThe denominator, e.g. 32 or 16.

Examples

Example 1 — Treasury quotes to decimals

Northstar's treasury desk receives prices in 32nds and 16ths.

C2fx=DOLLARDE(A2,B2)
ABC
1QuoteFractionDecimal
2101.0332101.09375
399.163299.5
41.02161.125

Common mistakes

  • #DIV/0! or #NUM!. fraction must be at least 1 (decimals are truncated).

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.