DOLLARFR Function

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.

This example is useful because it shows the reverse direction of the quote process. The sheet may calculate prices in decimals, but traders or reports may still want the result shown in fraction-style notation.

=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.

So the example is not only about one formula result. It also shows that the denominator controls how the decimal value will be displayed in the market's quote style.

=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.

That makes it helpful for validation work. Instead of only displaying the converted quote, the sheet can confirm that the result matches the market format you expected.

=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.

This is a good workflow example because it keeps math and display separate. The calculation stays clean in decimal form, and only the final output is turned into quote notation for the reader.

=DOLLARFR(1.125-1.0625,16)

Conclusion Recap

DOLLARFR is useful when the math is already done in decimals but the final answer needs to be shown in a fraction-style market quote. In this lesson, that meant converting decimal prices into sixteenths or eighths, checking expected quote outputs, and expressing a spread in the same quote style traders would expect to see.

The key idea is that this function changes the quote format, not the underlying value. So it works best at the output stage, after the calculation is finished and ready to be shown in the market’s preferred notation.

• 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.