Help with fractions
Posted by Steve Smith on September 16, 2000 6:56 PM
I need to create a spreadsheet for a friend to track his portfolio with. So far everything is great, except for fractions. I need it to display a value as a fraction, but it can only be x/2, x/4, x/8, x/16 or x/32. I formatted the cell to convert it to x/32, but then I end up with fractions like 16/32 and I need it to display it as 1/2. Example: A cell value is 39.87. When I format the cell to fraction (2 digits) it displays as 39 20/23. However, I need the closest value in one of the above mentioned formats, so the closest is 28/32. Now we all know this to be 7/8, but I cannot figure out how to get it to get it down to the lowest denominator.