Relative Reference
 

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.

Relative Reference
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


Don wrote:
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.

Relative Reference
 

That works perfectly THANKS !!!


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


--
Regards
Frank Kabel
Frankfurt, Germany


Don wrote:
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.
.