cell reference of a formula

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

Marzia

I am trying to get Excel to "know" which cell a formula is in and then count
a certain number of rows and columns to find where the data that needs to be
used in the calculation is.

For example if I have data that needs to be used in the calculation in C2:C6
and the formula is in B7, I need Excel to count one column to the right and 4
rows above from B7 to find the data and work out the result of the formula.

I can do the part about counting the rows and columns, but I can't find how
to get Excel to work out the cell reference for the formula cell. Is this
possible and how?
 
For example, if the formula in B7 is to take the cell one column to the right
and four rows up and multiply it by 11, then:

=C3*11

Will do it
 
I am trying to get Excel to "know" which cell a formula is in and then count
a certain number of rows and columns to find where the data that needs tobe
used in the calculation is.

For example if I have data that needs to be used in the calculation in C2:C6
and the formula is in B7, I need Excel to count one column to the right and 4
rows above from B7 to find the data and work out the result of the formula.

I can do the part about counting the rows and columns, but I can't find how
to get Excel to work out the cell reference for the formula cell. Is this
possible and how?
Click to expand...

Look up R1C1 reference style in Excel Help.

Alan Lloyd
 
Back
Top