RELATIVE CELL ADDRESSING

[imported_unknown]

hi,

Here's my question:

If I copy a formula (say =c2+c3 with relative cell addressing from a1 to b1, the formula becomes d2+d3. What can I do if I want the formula to say h2+h3. (5 columns further not the next one.

Thank you

 

[plettieri]

Hello,
Copying cell formulars into other cells can be relative....done by just copying from one cell to another...just as you describe...or copying using the absolute method...ie from a2 to $a$2 (by invoking the F4 key) when you are already positioned in the cell.

Is this the nature of your question....?

pll
This message was edited by plettieri on 2002-10-04 22:44

 

[Yogi Anand]

On 2002-10-04 22:32, STRUDEL wrote:
hi,

Here's my question:

If I copy a formula (say =c2+c3 with relative cell addressing from a1 to b1, the formula becomes d2+d3. What can I do if I want the formula to say h2+h3. (5 columns further not the next one.

Thank you

Hello STRUDEL:

You can use the OFFSET function to do this -- it is best explained with my simple worksheet simulation ...

y021005.xls
	A	B	C	D	E	F	G	H
1	13	15
2			5					6
3			8					9
Sheet4

</SPAN>

Regards!

Yogi