How do I copy a formula to another cell

G

Guest

I am trying to copy a basic addition formula from 1 cell to another...When I
do this it copies the cells correctly but gives me the answer from the
previous cell copied from.
example
A1 = 100, A2 = 100 so A3 would be A1+A2=A3 = 200
if i copy that formula from A3 to B3 I get the same ending firgure even if
my numbers in B1 and B2 are different.
 
P

Pete

You might have Calculation set to Manual - press F9 to see if the
values in B3 change. If so, go to Tools | Options | Calculation (tab)
and check Automatic Calculation.

Pete
 
G

Guest

=SUM(A1+A2) IN CELL A3
=SUM(B1+B2) IN CELL B3, but when i copy the formula from cell A3 to cell B3,
it changes the everything correctly except is carries the A3 calculation down
to B3 - it doesn't add the current cell information.
 
G

Guest

It sounds like your calculations are set to Manual instead of Automatic.

Select TOOLS
Select OPTIONS
Click on the CALCULATIONS tab
Change the setting to AUTOMATIC
Click OK

Or, if you'd rather leave calculations as Manual, then just hit F9 whenever
you want to update your formula values.

HTH,
Elkar
 

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

Top