adding two numbers, the added result do not change when changing the values in excel?

Question

I having 4 columns of A,B,C,D.
A and B having some values i want to store sum(A,B) in C column.
then i have to change the value of A now i store sum (new value(A),B) in D column. in this time the value of C column do not change. what i want to do for this? pls help me!!!

Answer 1

try pressing the F9 key on your keyboard.

if the value in C changes, then your

workbook is set to manual calculation

and needs to be changed to automatic

calculation to show changes dynamically



hope that helps

Answer 2

Before changing the Value in A do the following.



Select Column C

Press Ctrl + C (Copy)

Right click anywhere in the Selected Cell

Click Paste Special

Select Values under Paste

Click OK

Now Change the Value in A or B Column

Answer 3

An function is an activity conducted on one or more principles either to alter one value or to generate a new value by mixing current principles. Therefore, an function is conducted using at least one icon and one value. The icon used in an function is known as an owner. A varying or a value engaged in an function is known as an operand.