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.

"Jason52" wrote:

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