Google Spreadsheet Post #955
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan 05, 2013
user BRIAN ROBERY said:(http://productforums.google.com/forum/?zx=rwjvrrsr2c23#!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?
--------------------------------------------------------------------------------
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, ...)
No comments:
Post a Comment