equal to 1 cell above it

[anhqvo]

Hello everyone,

Please help......


I want to make a formula in a cell, which shows the value
of the cell above it, and it will not change when I insert
a new row in between them.

NOT this formula

A B C
1 5
2 =A1

When I do insert row between 1 and 2 above formula will
change like this

A B C
1 5
2
3 =A1 (I want to find a formula that understand when I
do insert it equal to A2 instead of A1, which mean one
cell above its original formula)

Please help

 

[Dave Peterson]

You can use a formula like this in A2:

=OFFSET(A2,-1,0)