View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Hi
You'll need to make the references absolute. So instead of
=A2+A3
use
=$A$2+$A$3
This means that when the formula is copied and pasted, the reference to the
original cells remains.

--
Andy.


"Kinjalip" wrote in message
...
Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified