| Excel's DOLLARDE and DOLLARFR functions let you | | | | them into an Excel worksheet cell to see the functions |
| easily convert security dollar prices from decimal | | | | in action. Again, however, note that you need to have |
| prices to fractional prices or from fractional prices to | | | | "turned on" the Add-in functions in order to get access |
| decimal prices. But note: In order to use either of these | | | | to the functions. |
| useful functions, you need to have first installed Excel's | | | | Using the DOLLARFR Function |
| add-in functions. (To install the Add-in functions, choose | | | | The DOLLARFR functions converts a dollar decimal |
| the Tools menu's Add-Ins command, check the | | | | price into a dollar fractional price given the decimal |
| Analysis Tookpak box, and then click OK.) | | | | price and the fraction's denominator. It uses the |
| Using the DOLLARDE Function | | | | following syntax: |
| The DOLLARDE function, for example, converts a | | | | DOLLARFR (decimal price, fraction) |
| fractional dollar price to an equivalent decimal price | | | | For example, to convert the price 10.125 to a fractional |
| based on the fractional price and the fraction's | | | | price in eighths, you use the following formula: |
| denominator. It uses the following syntax: | | | | =DOLLARFR (10.125,8) |
| DOLLARDE (fractional price, fraction) | | | | The function returns the value 10.1. |
| For example, to convert the fractional price 25 2/16 to | | | | Similarly, to convert the price 10.125 to a fractional price |
| an equivalent decimal price, you use the following | | | | in sixteenths, you use the following formula: |
| formula: | | | | =DOLLARFR (10.125,16) |
| =DOLLARDE (25.02,16) | | | | The function returns the value 10.02. |
| The function returns the value 25.125. | | | | NOTE When you work with the DOLLARDE and |
| And to convert the fractional price 25 1/8 to an | | | | DOLLARFR functions, remember that Excel expects |
| equivalent decimal price, you use the following formula: | | | | your fraction argument to be an integer. If it isn't, Excel |
| =DOLLARDE (25.1,8) | | | | uses just the integer portion. Also, Excel expects the |
| This function returns the value 25.125. | | | | fraction argument to be a positive value. If it isn't, Excel |
| Tip: You can copy the above functions and then past | | | | returns the #NUM! error value. |