The Excel Dollarde and Dollarfr functions are designed for working with security prices, which are often quoted as fractional values.
Some examples are given below:
| fractional notation | fraction | decimal |
|---|---|---|
| 1.01 (denominator 16) | 1 1/16 | 1.0625 |
| 1.1 (denominator 16) | 1 10/16 | 1.625 |
| 1.03 (denominator 32) | 1 3/32 | 1.09375 |
| 1.3 (denominator 32) | 1 30/32 | 1.9375 |
| 1.12 (denominator 32) | 1 12/32 | 1.375 |
The Excel Dollarde function converts a dollar value in fractional notation, into a dollar value expressed as a decimal.
The syntax of the function is:
Where the arguments are as follows:
| fractional_dollar | - | The dollar value, expressed as a fraction. |
| fraction | - |
The denominator for the fractional_dollar value. (Should be supplied as an integer, but if a decimal value is supplied, Excel will truncate this to an integer). |
The following spreadsheet shows the Excel Dollarde function, used to convert five fractional prices into decimal notation.
|
Formulas:
|
Results:
|
For further examples of the Excel Dollarde function, see the Microsoft Office website.
If you get an error from the Dollarde function, this is likely to be one of the following:
| #NUM! | - | Occurs if the supplied fraction argument is < 0. |
| #DIV/0! | - | Occurs if the supplied fraction argument = 0. |
| #VALUE! | - | Occurs if either of the supplied arguments is non-numeric. |