Numbers Formula to convert decimal values to fractions, then round them to nearest 32nd of an inch
In Numbers, I know I can simply copy and paste a column of decimal values into another column and use Formatting to get them to the nearest 16th, but I need the result to be rounded to the nearest 32nd of an inch, which is not offered in Numbers.
eg: 4.89 = "4~28/32" (and then reduced to "4 ⅞").
So I must use a formula instead. I'm looking for the complete syntax for the formula, since partial answers are plentiful on the internet.
I need to be able to insert the formula in a new column and have it work it’s magic on the decimal entries in a different column. Have searched and searched and not found a single, sensible answer anywhere. Help somebody!!
