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.
A
B
C
D
1
1.02
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .