Self Calculation

[krupasknr]

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

[#2]

@krupasknr 

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.