Summary

The Excel DOLLARDE function converts a dollar price expressed as an integer part and a fraction part into a decimal number. Microsoft uses the example 1.02 with a denominator of 16 to show that the value should be read as 1 and 2/16, which equals 1.125 in decimal form.

This function matters because some market quotes are stored in fractional notation, but most spreadsheet calculations need decimal numbers. If the quote is not converted first, comparisons, spreads, and downstream valuation logic can all be distorted.

DOLLARDE is therefore a quote-conversion function. Its job is not to value a security by itself, but to normalize a fractional-style number into a form that ordinary arithmetic can use safely.

Syntax

=DOLLARDE(fractional_dollar, fraction)

fractional_dollar is the quote written with an integer part and a fraction-style part, and fraction is the denominator that tells Excel how to interpret that quote. Microsoft notes that if the fraction is not an integer, it is truncated.

This denominator is essential. The same visible quote digits can represent different values depending on whether the market is quoting in eighths, sixteenths, or thirty-seconds.

Arguments

• fractional_dollar - The quote written in fraction-style notation.
• fraction - The denominator used to interpret the fractional part.

Microsoft also notes that invalid denominator values can return errors. If the denominator is less than 0, DOLLARDE returns #NUM!. If it is between 0 and 1, the function returns #DIV/0!.

DOLLARDE vs Other Functions

DOLLARDE is best understood as the reverse of DOLLARFR. Both functions convert quote formats, but in opposite directions.

Use DOLLARDE when the problem is about format conversion. Use pricing or yield functions only after the quote format has already been normalized.

Using the DOLLARDE Function

DOLLARDE is most useful when data arrives in market-style notation but the worksheet needs consistent decimal prices for arithmetic. Once converted, the result can be compared, added, subtracted, or used in valuation formulas without ambiguity.

It also helps prevent a common error: treating the digits after the decimal point as ordinary decimal places when they really represent a fractional numerator.

• Use DOLLARDE before doing arithmetic on fraction-style market quotes.
• Confirm the denominator from the quoting convention instead of guessing it from the number alone.
• Keep converted values and raw quote-format values clearly separated in the worksheet.

Example 1 - US Bond Fraction (1/16)

This formula converts 1.02 in sixteenths into a decimal number. Because the fraction part means 2/16, the result is 1.125 rather than 1.02 in ordinary decimal notation.

=DOLLARDE(1.02,16)

Example 2 - High-Resolution Fraction (1/32)

With a denominator of 32, the quote 1.08 is interpreted as 1 and 8/32, not 1.08 in standard decimal form. This example shows why the denominator must be known before the quote can be interpreted correctly.

=DOLLARDE(1.08,32)

Example 3 - Price Threshold Check

This comparison first converts the sixteenths quote into decimal form and then checks it against a decimal threshold of 1.10. That sequence matters because the raw fractional-style number and the converted decimal are not equivalent values.

=DOLLARDE(1.02,16)>1.1

Example 4 - Dynamic Arbitrage Gap

Subtracting the converted quote from a target decimal price gives a clean spread measure. This is a practical example of why quote-format conversion usually has to happen before any spread or gap analysis.

=1.125-DOLLARDE(1.02,16)

Conclusion Recap

• Summary: DOLLARDE converts a fraction-style dollar quote into a decimal number.
• Syntax: =DOLLARDE(fractional_dollar,fraction).
• Core setup: Use the correct denominator, because it determines how the quote is interpreted.
• Best use: Market quote normalization, spread analysis, and downstream pricing calculations.