Cell D1 contains this formula: =A1+(B1*C1). An absolute cell reference does not change when the formula is moved.Ĭonsider this example: Starting in A1 you have a 3×3 table with some figures in it. A relative cell reference adjusts to its new location when the formula is copied or moved.
When you create a cell reference in an Excel formula that refers to another cell, that cell reference can be relative (the default) or absolute.
