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 ...
This remains problematic.
Let's say you have entered 5 in C16 and 6 in E16. The sum 11 is calculated in F16.
Now you discover that C16 should actually have been 4.
How should Excel decide whether you want to update the total in F16 to 4+6 =10, or you want to adjust E16 to 11-4=7, keeping the total the same?
Do you have a decision rule for that?
Great question!
Do you have a decision rule for that?
what can I say? in my documents I always have the sum (F16) of the 6% (C16) and 23% (E16) tax. So, whenever I enter the total value, I want that value to remain, because I'm sure that value (F16) is right.
(I want the total (F16) dont change if I am to introduce it)
Thanks