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

"cfiser" wrote in message
...
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.