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.
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.
No comments:
Post a Comment