Always Display value in active cell cell x-rows above it ?

[Guest]

I am trying to display the value from 2 rows above in the currently active
cell.
for example display in active cell c15 the value from c13 (15-2=13)

If I insert 4 new rows after c13 [ c14,c15,c16,c17 ]
I then want the value of C17 to be displayed in C19(the former c15)

What is the formula to do this?
Dynamically change the value of the active cell the value to display the
value of the cell 2 rows above

 

[John W. Vinson]

I am trying to display the value from 2 rows above in the currently active
cell.

I'd suggest reposting in an Excel newsgroup. This group is for a different
program, Microsoft Access. The webpage can be confusing! Scroll down the list
of subject areas and find one for Excel.

John W. Vinson [MVP]