If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute. Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet.
当要引用工作表中的某一个单元格进行计算时，请使用绝对引用。如果您没有将单元格设定为绝对引用，那么，当将引用了此单元格的公式复制到源单元格下方的单元格中时，引用的单元格也将跟着下移。