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.


Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.