i have created a circular reference on purpose, with the intent to enter data in one column that is automatically added and stored in another column. for example, i have cell d3 set up as a formula =b3+d3. originally, d3 is set to 0. when i enter data into b3 it updates d3 by the value entered in b3.
if it were just the one cell there would be no problem, but i am doing this for d3, d4, and d5 respectively. the problem occurs as follows. when i enter my value for b3, d3 is updated correctly. if i enter a value in b4 to update d4 and have not cleared out the value in b3, the value for d3 is again increased by the value in b3.
i can manually clear out each value after i have entered them, but i was wondering if there is a way to clear contents of the cell once hitting the enter button or if there is a better way to avoid this problem.
if it were just the one cell there would be no problem, but i am doing this for d3, d4, and d5 respectively. the problem occurs as follows. when i enter my value for b3, d3 is updated correctly. if i enter a value in b4 to update d4 and have not cleared out the value in b3, the value for d3 is again increased by the value in b3.
i can manually clear out each value after i have entered them, but i was wondering if there is a way to clear contents of the cell once hitting the enter button or if there is a better way to avoid this problem.