Forum Discussion
Self Calculation
Hi,
Since some time, i trying to do this. But, i haven't found any solution for this.
The problem is, i want excel to add the value when i enter a value in that cell.
for example, a cell has 150 in it, when i enter 70 it should show the value 220 in that cell only,
i hope someone found a solution and will help me
thanks
1 Reply
Although it is possible, I would not recommend doing that. You'd have no way to know what contributed to the end result, so no way to correct errors.
I'd enter the values in a column, each value in its own cell. In a cell elsewhere, use the SUM function to add up the values. That will allow you to inspect and if necessary correct the values.
