If you want to copy a formula without it changing the reference, have you
looked at the difference between absolute and relative addressing?
--
David Biddulph

"Ms_M_o_n_i_c_a" wrote in message
...
THANKS. i worked. now i just need to figure out how to copy forumula
without
changing the reference
--
I will Excel at Excel!


"Max" wrote:

OTOH, if this statement of yours is key
.. i want a1 to equal a2 no matter what

Then
in A1: =IF(INDIRECT("A2")=0,"",INDIRECT("A2"))

Or, if you need to propagate it across from A1,
use this in A1:
=IF(OFFSET(INDIRECT("A1"),1,COLUMNS($A:A)-1)=0,"",OFFSET(INDIRECT("A1"),1,COLUMNS($A:A)-1))
then copy A1 across to return correspondingly from row2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---