Ask Your Question

Revision history [back]

If I understand your question, there is nothing you have to do, given the formula as configured, except copy the cell and paste it in the target range (or drag the fill handle to paint the entire range). Here is why:

There are two types of cell adderss referencing: 1) absolute and 2) relative. Absolute cell address references preceed column and/or row coordinates with a dollar sign ("$") to indicate to the spreadsheet app that the reference is locked in place. In other words, $A$1 won't change as you copy or move it.

Relative cell addresses, on the other hand, do change as you copy or move them. A reference to cell A1 will change to A3 if moved or copied two cells down from its current location.

I hope this helps.

If you believe my response best answers your question, please click the checkmark next to my response.

If I understand your question, there is nothing you have to do, given the formula as configured, except copy the cell and paste it in the target range (or drag the fill handle to paint the entire range). Here is why:

There are two types of cell adderss referencing: 1) absolute and 2) relative. Absolute cell address references preceed precede column and/or row coordinates with a dollar sign ("$") to indicate to the spreadsheet app that the reference is locked in place. In other words, $A$1 won't change as you copy or move it.

Relative cell addresses, on the other hand, do change as you copy or move them. A reference to cell A1 will change to A3 if moved or copied two cells down from its current location.

I hope this helps.

If you believe my response best answers your question, please click the checkmark next to my response.