Try something like this:

C1: =OFFSET(C1,0,-1)-OFFSET(C1,0,-2)
Copy that cell down as far as needed

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BradleyP" wrote:

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.