Forum Discussion
Sum and subtraction
Hi, First, I'm sorry for my english (I used the google translator to help me) i have three cells. a1 a2 and a3. a3 is sum of a1+a2 a3= a1 +a2, example 8 = 2+6, but I want also be possible ...
I am afraid that this doesn't make sense.
In the first place, a1 = a2-a3 and a2 = a1-a3 are not equivalent to a3 = a1+a2.
In the second place, what do you want to happen when you change one cell? Which cell should be kept the same, and which one should be changed?
For example, if I change cell A1, should I change the sum in A3, or should I keep the sum the same and change cell A2 so that A3 still equals A1+A2?
And if I change cell A3, should I keep A1 the same and change A2, or should I keep A2 the same and change A1?