Excel functions / Financial
DOLLARDE function
Turns a price written with a fraction, as bond prices are (1.02 meaning 1 and 2/16), into an ordinary decimal.
Syntax
=DOLLARDE(fractional_dollar, fraction)
Arguments
fractional_dollar: The price: the whole part, a point, then the top of the fraction.fraction: The bottom of the fraction: 16 for sixteenths, 32 for thirty-seconds.
When to use it
DOLLARDE turns a price quoted with a fraction, as bonds and some commodities are, into an ordinary decimal. 1.02 in sixteenths means 1 and 2/16, which is 1.125.
Examples
A price in sixteenths
A B C 1 Quoted 2 1.02 1.125 In C2:
=DOLLARDE(A2, 16)→ 1.125A price in thirty-seconds
A B C 1 Quoted 2 1.1 1.3125 In C2:
=DOLLARDE(A2, 32)→ 1.3125
Common mistakes
- Reading 1.1 in 32nds. After the point is the top of the fraction: 1.1 in thirty-seconds is 1 and 10/32.
DOLLARDE 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: DOLLARDE
- Danish: KR.DECIMAL
- Dutch: EURO.DE
- Finnish: VALUUTTA.DES
- French: PRIX.DEC
- German: NOTIERUNGDEZ
- Hungarian: FORINT.DEC
- Italian: VALUTA.DEC
- Norwegian: DOLLARDE
- Polish: CENA.DZIES
- Portuguese (Brazil): MOEDADEC
- Portuguese (Portugal): MOEDADEC
- Russian: РУБЛЬ.ДЕС
- Spanish: MONEDA.DEC
- Swedish: DECTAL
- Turkish: LİRAON
Try DOLLARDE in the playground