Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers

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.

share|improve this answer
add comment

You also have the option of naming the cell.

The box where the AA7 is written when you select the field is editable. So you can give it a context-friendly name, and use that in your calculations.

IE. name the field "interest" and use =H8+N8*interest

share|improve this answer
    
Can you explain how to name the field please? –  Dave Rook Aug 10 '12 at 11:57
    
See 1-2-3 steps here: imageshack.us/photo/my-images/444/excellabels.png just select the field, type the name + enter, and use your new label everywhere. To move a label to another field, you must cut and paste the label-field to its new position. –  Thomas Aug 10 '12 at 12:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.