Summary

The Excel DOLLARFR function converts a decimal number into a dollar price expressed as a fraction. Microsoft describes it as the reverse of DOLLARDE, which makes it useful when a model has already calculated a decimal value but needs to present the result in a market quote convention.

The output is still numeric, but it is written in a fraction-style format such as 1.02 to mean 1 and 2/16 when the denominator is 16. That is an important distinction because the result should be read according to the denominator, not as an ordinary decimal number.

DOLLARFR is therefore a presentation and compatibility function. It helps align a spreadsheet result with the quoting style used in a market or reporting workflow.

Syntax

=DOLLARFR(decimal_dollar, fraction)

decimal_dollar is the decimal number to convert, and fraction is the denominator that determines the quote basis. Microsoft notes that if the denominator is not an integer, it is truncated.

Because the denominator controls how the output should be read, a change from eighths to sixteenths or thirty-seconds changes the visible quote format even if the underlying decimal value is the same.

Arguments

• decimal_dollar - The decimal number to convert.
• fraction - The denominator for the fraction-style quote.

Microsoft also notes that if the denominator is less than 0, DOLLARFR returns #NUM!. If the denominator is 0, the function returns #DIV/0!.

DOLLARFR vs Other Functions

DOLLARFR and DOLLARDE are complementary functions that move between two quote conventions.

Use DOLLARFR when the underlying number is already correct in decimal form and only the quote convention needs to change.

Using the DOLLARFR Function

DOLLARFR is most useful near the output layer of a worksheet. Calculations are usually easier in decimal form, but reports or market-facing inputs may still need to be expressed in fractional notation.

It also helps keep quote conversion explicit. Instead of manually formatting or approximating the fraction-style representation, the worksheet can show exactly which denominator was used.

• Use DOLLARFR after the decimal calculation is already complete.
• Choose the denominator that matches the market quoting convention.
• Remember that the result is a number written in fraction-style notation, not a text label.

Example 1 - US Bond Fraction (1/16)

This formula converts the decimal price 1.125 into sixteenths notation. Because 0.125 equals 2/16, the returned number is read as 1 and 2/16.

=DOLLARFR(1.125,16)

Example 2 - Commodity Fraction (1/8)

Using a denominator of 8 expresses the same decimal logic in eighths notation. This is useful when the output must match a different quoting basis from the one used in another market.

=DOLLARFR(1.25,8)

Example 3 - Quote Threshold Check

This equality test checks whether 1.0625 converts to 1.01 in sixteenths notation. It is a useful audit pattern when the worksheet needs to verify the expected quote output exactly.

=DOLLARFR(1.0625,16)=1.01

Example 4 - Dynamic Spread Label

First the spread is computed in decimals, then it is converted into sixteenths notation. This is a practical example of why it is usually better to calculate first and convert the presentation format afterward.

=DOLLARFR(1.125-1.0625,16)

Conclusion Recap

• Summary: DOLLARFR converts a decimal number into a fraction-style market quote.
• Syntax: =DOLLARFR(decimal_dollar,fraction).
• Core setup: Use the correct denominator and treat the result as a numeric quote representation, not as ordinary decimal notation.
• Best use: Output formatting for market quotes, decimal-to-fraction conversion, and quote-basis reporting.