answer of formula doesnt change after original value is changed,

G

Guest

I tried to work in an excel worksheet. I entered a formula on a cell for eg,
A10 with values from other cells, for eg, A1, A2, A3. The answer was correct.
Then i wanted to change the values in cell A1, A2. But the answer is not
changing. When looking at the formula auditing, its stilling showing the link
to A1, A2 and A3. I am confused. Can you please help me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy COUNTIF while retaining reference 7
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Help Creating Excel Formula 4
Change Cell colour on click 5
Two functions in one formula. 1
Two functions in one formula. 1
matching cell formula 1
display calculation steps - not final answer 2

Top