DOLLARDE function
DOLLARDE converts a price written in fractional notation, such as 1.02 for one and two sixteenths, into an ordinary decimal number. It is used with older bond price quotes.
Example
Read it as a sentence: convert the fractional price 1.02, meaning 1 and 2/16, into a decimal number, which gives 1.125.
A
B
C
D
1
1.125
2
3
Syntax
DOLLARDE(fractional_dollar, fraction)
-
fractional_dollar(required) - Price written as whole.fraction, e.g. 1.02 for 1 and 2/16.
-
fraction(required) - Denominator of the fraction (whole number).
Returns: The price as an ordinary decimal number.
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 |
|---|---|---|
=DOLLARDE(1.02,16) | 1.125 | 1.02 / 16 |
=DOLLARDE(1.1,32) | 1.3125 | 1.1 / 32 |
=DOLLARDE(-1.02,16) | -1.125 | Negative |
=DOLLARDE(1.02,16.9) | 1.125 | Fraction 16.9 truncates |
=DOLLARDE(1.5,1) | 1.5 | Fraction 1 |
=DOLLARDE("1.02","16") | 1.125 | Text number |
=DOLLARDE(1.02,0) | #DIV/0! | Fraction 0 |
=DOLLARDE(1.02,-1) | #NUM! | Fraction negative |
Watch out for
- A fraction below 1 returns #NUM! and 0 returns #DIV/0!.
- The digits after the point are the numerator, not a decimal.
Where it works
- Excel
- DOLLARDE 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 .