fractions

[stebrownsword]

hi all,

how do you add fractions?

example
Cells A1 A2 A3 A4
1/3 + 4/10 + 25/40 = 30/53


thanks in advance

 

[Richard Schollar]

Have you got numeric values in the cells (ie they are just formatted to display as fractions)? If so then you can just use SUM():

=SUM(A1:A3)

I would check your maths though cos that isn't what I get with those numbers!

 

[jasonb75]

Same as any other number =SUM(A1:A3)

But the results will be nothing like yours, remember fractions are proportional so your example would be

1/3 + 2/5 + 5/8 = 4/3 (1 1/3)

 

[moonfish]

The sum of those fractions is 163/120.

http://en.wikipedia.org/wiki/Fraction_(mathematics)#Addition

Simple example why your logic is flawed: 1/2 + 1/2 = 1. According to your logic it is (1+1) / (2+2) = 2/4 = 1/2.

 

[stebrownsword]

thanks guys