In my excel 2010 worksheet, I have entered a formula =+H8+N8*AA7
where AA7 is a permanent number where as H20 & N20 will change.
But if I copy this formula to the below row, it pastes as =+H8+N8*AA9
, the next row =+H8+N8*AA11
and then again to =+H8+N8*AA13
etc.
In this formula, I always need to multiply the H & N column by AA7. But AA7 keeps on changing. Please give the reason & a solution.
Thanks.
Best Answer
Use the $ sign to force the cell reference (AKA absolute cell reference).
If want to keep both cell and column type $AA$7 (regardless of where you drag the formula too).
EG
=+H8+N8*$AA$7
You may also need to use the Indirect keyword.
Further examples of the absolute cell reference.