equal to 1 cell above it


A

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Equal Cells 2
1 equals 3 2
Cell Equality 5
how to increase the number by 1 from the cell above? 2
Cells equal a number 3
Sum equal cells 2
Painting equal cells 2
Getting 0 to equal 1 9

Top