fx
FunctionPedia
Quick Answer

DOLLARFR Function

Converts a decimal dollar price into a fractional dollar price.

✓ Excel✓ Google SheetsExcel All versions

Syntax

DOLLARFR
(decimal_dollar, fraction)

Parameters

ParameterDescriptionRequired
decimal_dollarDecimal number to convert to a fraction.Required
fractionInteger to use in the denominator of the fraction.Required

Basic Example

Convert 1.125 to sixteenths

=DOLLARFR(1.125, 16)
Result1.02

1.125 equals 1 and 2/16, so the result is 1.02.

Advanced Examples

Example 1: Bond price in 32nds

Fixed income quoting

Convert 100.50 to 32nds

=DOLLARFR(100.50, 32)
Result: 100.16
100.50 equals 100 and 16/32.

How DOLLARFR Works

DOLLARFR converts a decimal value to a number where the integer part is the whole dollar amount and the decimal part is the numerator over the specified fraction.

1
Enter decimal_dollar
Type the decimal_dollar
2
Enter fraction
Type the fraction
3
Calculate
Press Enter to get the result.

Important Notes & Limitations

  • Fraction must be an integer.

  • Result is not a true fraction but a number in fractional notation.

  • Use DOLLARDE to convert back to decimal.

Common Errors & Fixes

#DIV/0! errorFraction is zero.

Fix: Use a non-zero integer.

#VALUE! errorFraction is not an integer.

Fix: Use an integer for the fraction.

Download Practice File

Practice DOLLARFR with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the DOLLARFR function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Frequently Asked Questions

What is the difference between DOLLARFR and DOLLARDE?
DOLLARFR converts decimal to fractional. DOLLARDE converts fractional to decimal.
When is DOLLARFR used?
It is used to display bond prices in fractional notation.