Relative Reference

[Don]

I am trying to create a formula with a relative
reference. I want to name a cell like BEGCELL. Then I
want to be able to calculate based on the row of that
cell. For example my first formula will be =BEGCELL +
(BEGCELL+16 rows same column) then my next formula will
be =(BEGCELL+20 rows same column) + (BEGCELL+36 rows same
column) and so on.
What I'm trying to acieve is that if my row number
changes I only have to make one change and the rest of my
formulas will adjust. Thanks for the help.

 

[Frank Kabel]

Hi
maybe something like
=OFFSET(BEGCELL,16,0)

 

[Don]

That works perfectly THANKS !!!

-----Original Message-----
Hi
maybe something like
=OFFSET(BEGCELL,16,0)


--
Regards
Frank Kabel
Frankfurt, Germany


.