Excel functions / Financial
DOLLARFR function
Turns a decimal price into one written with a fraction, as bond prices are: 1.125 in sixteenths is 1.02.
Syntax
=DOLLARFR(decimal_dollar, fraction)
Arguments
decimal_dollar: The price as an ordinary decimal.fraction: The bottom of the fraction: 16 for sixteenths, 32 for thirty-seconds.
When to use it
DOLLARFR turns a decimal price into the fractional notation bond prices use: 1.125 in sixteenths is written 1.02.
Examples
In sixteenths
A B C 1 Price 2 1.125 1.02 In C2:
=DOLLARFR(A2, 16)→ 1.02
Common mistakes
- A number, not a fraction. The result is still a number: read 1.02 as "1 and 2/16".
DOLLARFR in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DOLLARFR
- Danish: KR.BRØK
- Dutch: EURO.BR
- Finnish: VALUUTTA.MURTO
- French: PRIX.FRAC
- German: NOTIERUNGBRU
- Hungarian: FORINT.TÖRT
- Italian: VALUTA.FRAZ
- Norwegian: DOLLARBR
- Polish: CENA.UŁAM
- Portuguese (Brazil): MOEDAFRA
- Portuguese (Portugal): MOEDAFRA
- Russian: РУБЛЬ.ДРОБЬ
- Spanish: MONEDA.FRAC
- Swedish: BRÅK
- Turkish: LİRAKES
Try DOLLARFR in the playground
Related functions
- DOLLARDE: Turns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.