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
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.