Saturday, January 5, 2013

yogi_Convert Decimal Numbers In Column A Row By Row To The Nearest 32nd (or another specified denominator)

                                          Google Spreadsheet   Post  #955
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 05, 2013
user BRIAN ROBERY  said:(!category-topic/docs/spreadsheets/kXg707tuJRM)
convert decimals to fraction in 32nds of an inch
Hello, I am trying to get a google spreadsheet to convert a decimal to a fraction to the nearest 32nd of an inch.
I have tried the formula in dec2frac but it comes back to an absolute fraction. Is it possible to get it to go to a specific denominator?

following is solution to a bit more generalized problem in that the denominator of the fraction can be specified in cell B3 (what I mean is that I change 32 in cell B3 to say 16, or 64, or 8, or 128, ...)