Can you build a formula in one cell with flexibility

[Guest]

I have a simple division equation in one cell. It calculates from two other
cells. The two cells may have to be moved down (not the entire row, just a
portion of row). But the cell with the calculation follows this shift. I
need for that calculation cell to be smart and after I shift the cells that
make up the calculation, I need for the original cells to still be part of
the calculation cell

 

[Guest]

Create a name for the cell or cells. That way if you insert cells above it
or delete cells, those cells with always be named the same.
For instance. Name B4 "Price", B5 "Qty". B6 formula: Instead of =b4*b5,
do =price*qty. Those name will follow that cell whether you insert a row or
just a cell.

 

[Guest]

I'm not sure I understand your question.

If I have 1 in A2 and 2 in B2 and =A2/B2 in C1 and then insert a row
between rows 1 and 2, the number values in A2 and B2 move to A3 and B3.
However, the formula in C1 calculates correctly because the cell references
change with the row insertion.

Maybe post the formula you're talking about--are you using absolute
references?

Dave