Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an inventory spreadsheet where I compare the values in 2 columns to
make sure they equal 0. If the 2 values in each row to equal 0 when I subtract one from the other (A23-B23), this lets me know that the inventory price has not changed. However, because the new inventory list may have more or less items that the current inventory list, I have to move cells up or down to align the similar inventory parts. I want to put a column to the side where I subtract current inventory value from new inventory value and get a result of 0. But when I move one column up or down, the formula changes accordingly. I want to be able to freeze the formula column so that it always says "A23-B23" even when I move A23 up or down. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you move cells with a formula | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Formula to Sum Cells that Hold If Formulas | Excel Worksheet Functions | |||
Freezing cells | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) |