Weird formula block
 

I am getting stressed - When I copy a formula, it reads correctly but won't
compute correctly. Like is reads C1+C2 but the cell contains the results from
where I copied the formula from - like the total of A1+A2. How can I get it
back?
Carole

Sounds like you have automatic calculation turned off?
Tools--Options--Calculation tab.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Carole Drake" wrote in message
...
I am getting stressed - When I copy a formula, it reads correctly but
won't
compute correctly. Like is reads C1+C2 but the cell contains the results
from
where I copied the formula from - like the total of A1+A2. How can I get
it
back?
Carole

aahhhhhh! Thank you SO much

"Anne Troy" wrote:

Sounds like you have automatic calculation turned off?
Tools--Options--Calculation tab.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Carole Drake" wrote in message
...
I am getting stressed - When I copy a formula, it reads correctly but
won't
compute correctly. Like is reads C1+C2 but the cell contains the results
from
where I copied the formula from - like the total of A1+A2. How can I get
it
back?
Carole