DOLLARDE

The DOLLARDE function is a financial function which converts values pricing entered with a particular fractional notation into an equivalent decimal number. It can be used for securities where pricing is given to the nearest 1/8, 1/16, 1/32, etc. For example, to convert the price "3 and 1/16" to an equivalent decimal value, you can use the DOLLARDE function like this: Notice first argument shows the whole dollar value on the left, and the decimal component is used to express the numerator (.01 = 1, .11 = 11, etc.). The second argument is the denominator. In the example shown, the formula column E, copied down, is: On each row, the DOLLARDE function picks up the fractional dollar notation from column C and the denominator from column D.