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