For example, to convert the price “1 and 1/16” to decimal notation for pricing given to the nearest 1/16, you can use the DOLLARFR function like this: Notice the first argument is a normal decimal value. The second argument is used to indicate the denominator of the fractional multiple to use for the conversion, i.e. 8 = 1/8, 16 = 1/16, 32 = 1/32, etc. In the example shown, the formula column E, copied down, is: On each row, the DOLLARDE function picks up the decimal value from column C and the fraction denominator from column D.
Notes
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.
