Practice free

DOLLARFR function

DOLLARFR turns a decimal price into whole.fraction notation, so 1.125 with a denominator of 16 becomes 1.02. It is the reverse of DOLLARDE and is used with older bond price quotes.

Example

Read it as a sentence: convert the decimal price 1.125 into fraction notation with 16 as the denominator, which gives 1.02.

Practice this in the app

Syntax

DOLLARFR(decimal_dollar, fraction)

decimal_dollar (required)
Price as a decimal number.
fraction (required)
Denominator of the fraction (whole number).

Returns: The price in whole.fraction notation.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=DOLLARFR(1.125,16) 1.02 1.125 / 16
=DOLLARFR(1.125,32) 1.04 1.125 / 32
=DOLLARFR(-1.125,16) -1.02 Negative
=DOLLARFR(1.125,16.9) 1.02 Fraction 16.9 truncates
=DOLLARFR("1.125","16") 1.02 Text number
=DOLLARFR({1.125,1.5},16) 1.02 Spill
=DOLLARFR(1.125,0) #DIV/0! Fraction 0
=DOLLARFR(1.125,-1) #NUM! Fraction negative

Watch out for

  • The result looks like a decimal but its digits are a numerator.

Where it works

Excel
DOLLARFR is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .