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