this cell reference is based on the relative position of the sun that contains the formula and the cell the reference refers to if the position of the cell that contains the formula changes to references changed
Home
/
this cell reference is based on the relative position of the sun that contains the formula and the cell the reference refers
Answer:
If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. These are called "relative" cell references, since they change relative to where you copy the formula.