If a formula contains the relative cell reference J7 and the formula is copied to a cell two rows down and one row to the right,the reference will become K9.

Question

Quizplus · Accepted Answer

This is because the relative reference J7 will shift 2 rows down to become J9 (since it moves down with the rows) and one column to the right to become K9 (since it moves right with the columns).

If a Formula Contains the Relative Cell Reference J7 and the Formula