Relative cell reference
 

Is it a way to make a formula containing a relative cell reference that e.g.
change one step when copying cell 2 steps.
--
~roar

Relative cell reference
 

the indirect function may do what you want
I am not sure what you want to do
if effectively you have
=b1 in A1
and you want to have
=b3 is A2
then try
=indirect("B"&(row()*2-1))
in A1
and copy down

there are other methods which may work better depending on the details of
what you are doing.

"Roar" wrote:

Is it a way to make a formula containing a relative cell reference that e.g.
change one step when copying cell 2 steps.
--
~roar