Self Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-3369534%22%20slang%3D%22en-US%22%3ESelf%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3369534%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BSince%20some%20time%2C%20i%20trying%20to%20do%20this.%20But%2C%20i%20haven't%20found%20any%20solution%20for%20this.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%2C%20i%20want%20excel%20to%20add%20the%20value%20when%20i%20enter%20a%20value%20in%20that%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%2C%20a%20cell%20has%20150%20in%20it%2C%20when%20i%20enter%2070%20it%20should%20show%20the%20value%20220%20in%20that%20cell%20only%2C%3C%2FP%3E%3CP%3Ei%20hope%20someone%20found%20a%20solution%20and%20will%20help%20me%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3369534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3369604%22%20slang%3D%22en-US%22%3ERe%3A%20Self%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3369604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1389319%22%20target%3D%22_blank%22%3E%40krupasknr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlthough%20it%20is%20possible%2C%20I%20would%20not%20recommend%20doing%20that.%20You'd%20have%20no%20way%20to%20know%20what%20contributed%20to%20the%20end%20result%2C%20so%20no%20way%20to%20correct%20errors.%3C%2FP%3E%0A%3CP%3EI'd%20enter%20the%20values%20in%20a%20column%2C%20each%20value%20in%20its%20own%20cell.%20In%20a%20cell%20elsewhere%2C%20use%20the%20SUM%20function%20to%20add%20up%20the%20values.%20That%20will%20allow%20you%20to%20inspect%20and%20if%20necessary%20correct%20the%20values.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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.