Calculate the position of a formula and number of cells from it

  • Thread starter Thread starter Marzia
  • Start date Start date
M

Marzia

Hi I have a formula which needs to work out which cell it is located in, then
calculate the reference or another cell 1 column to the right and 4 rows
above to use as reference in the formula itself. Is this possible? I can
workout the second part using the CELL function with "row" but the first bit
keeps eluding me.

Can anybody help?
 
The reference is automatic. For your example, say we want to formula to add
7 to the reference cell and the formula is in A10:

=B6+7

The refers to one cell to the right and four rows up.

If the formula is copied, the relative reference will adjust.
 
Back
Top