software

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.
How do you do the copy?
What formula shows in the Formula Bar for B3?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;cfiserquot; gt; wrote in message
...
gt;I am trying to copy a basic addition formula from 1 cell to another...When
gt;I
gt; do this it copies the cells correctly but gives me the answer from the
gt; previous cell copied from.
gt; example
gt; A1 = 100, A2 = 100 so A3 would be A1 A2=A3 = 200
gt; if i copy that formula from A3 to B3 I get the same ending firgure even if
gt; my numbers in B1 and B2 are different.
gt;
gt;
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=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.

quot;Bernard Liengmequot; wrote:

gt; How do you do the copy?
gt; What formula shows in the Formula Bar for B3?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;cfiserquot; gt; wrote in message
gt; ...
gt; gt;I am trying to copy a basic addition formula from 1 cell to another...When
gt; gt;I
gt; gt; do this it copies the cells correctly but gives me the answer from the
gt; gt; previous cell copied from.
gt; gt; example
gt; gt; A1 = 100, A2 = 100 so A3 would be A1 A2=A3 = 200
gt; gt; if i copy that formula from A3 to B3 I get the same ending firgure even if
gt; gt; my numbers in B1 and B2 are different.
gt; gt;
gt; gt;
gt;
gt;
gt;

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

quot;cfiserquot; wrote:

gt; =SUM(A1 A2) IN CELL A3
gt; =SUM(B1 B2) IN CELL B3, but when i copy the formula from cell A3 to cell B3,
gt; it changes the everything correctly except is carries the A3 calculation down
gt; to B3 - it doesn't add the current cell information.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt; gt; How do you do the copy?
gt; gt; What formula shows in the Formula Bar for B3?
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt; quot;cfiserquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I am trying to copy a basic addition formula from 1 cell to another...When
gt; gt; gt;I
gt; gt; gt; do this it copies the cells correctly but gives me the answer from the
gt; gt; gt; previous cell copied from.
gt; gt; gt; example
gt; gt; gt; A1 = 100, A2 = 100 so A3 would be A1 A2=A3 = 200
gt; gt; gt; if i copy that formula from A3 to B3 I get the same ending firgure even if
gt; gt; gt; my numbers in B1 and B2 are different.
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;