What does it mean for a cell to be addressed as absolute vs. relative? How can you tell the difference?
It is imperative to understand the differences between these two cell references because it is essential to properly using and understanding formulas in excel.
If a cell is addressed as absolute, when any copying is made of cells with functions using that cell reference, the part(s) that is absolute will not change with respect to which direction the formula was copied. If it is relative however, it will change.
The idea of how Absolute vs. relative works can be explained very simply by creating a simple multiplication table in excel, as shown above. No matter where in the table you look, the numbers in column D will be multiplied by the numbers in row 2.
Think you’ve got it? Try making a multiplication table for yourself in excel!
Excel bible 2007. Walkenbach, John pg 175-204
No comments:
Post a Comment