Here is my situation. I am trying to make a spreadsheet in microsoft excel. i want to be able to input a number in A7 and have it automatically change A6 That i know how to do. but then i want to be able to put a different number in A7 and have it change A6 using it's previous value. for example. A6 = 12. I enter 5 in A7. A6 now = 17. i want to be able to delete 5, enter 6 and now have A6 = 23. i personally don't think it is possible and i have researched to no avail. however any help is appreciated. i am fairly expirienced with excel so don't be afraid to use terminology. if this is not possible suggestions for other programs to use will help also. thanks again.
Adding in Microsoft Ecxel
- Thread starter k_dog14
- Start date
ceewi1
VIP Member
This might not be what you're after, but if we're on the same wavelength, it has to do with circular iteration. Go to Tools -> Options -> Calculation. Tick iteration, and set max iterations to 1.
Now set A6=A6+A7 (in your example). Whenever you put a new number in A7, A6 will increase by that number.
Now set A6=A6+A7 (in your example). Whenever you put a new number in A7, A6 will increase by that number.