formula stays same in cell when new row is inserted

[drandall]

When I insert a new row, I would like to keep the formula in a cell from
moving down. I believe I used to use the $ sign around the cell in the
formula, but this no longer works with 2003.

 

[Ray A]

See what Chip Pearson has to say about relative and absolute cell references
http://www.cpearson.com/excel/relative.htm