Tuesday, December 27, 2011

yogi_Sum Up Fractions And Present The Result In Fractional Notation

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Stars1234 said:
add inch fractions
I need to add standard length inch fractions based on the denominator.
for example: 1/2 + 1/8 = 5/8; 3/16 + 5/16 = 1/2
and make a formula to paste into columns
cell    data
A1     1/32
A2     =A1 + 1/32  ---answer would be 1/16
A3     =A2 + 1/32  ---answer would be 3/32
the answer needs to be in fractions, not decimals.
is there a way to do this?
in the following solution to the problem, I have generalized summing up of fractions and not limit it to adding inch fractions only.