Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add flexibility to Criteria of DFunctions | Excel Worksheet Functions | |||
Build Formula | Excel Worksheet Functions | |||
HD I build funct @if cell=AorBorC then ...else if cell=DorE then | Excel Worksheet Functions | |||
How would I build an "if" formula... | Excel Worksheet Functions | |||
Trying to build a formula | Excel Worksheet Functions |