Can you build a formula in one cell with flexibility
 

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

Can you build a formula in one cell with flexibility
 

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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

Can you build a formula in one cell with flexibility
 

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