formula cell column and row number changing when populating thenext cell row

HI

Have made a chart. The cell formula is simple and is figured out. When I place the formula in the cell and I call out for example "B4" in the formula and I also reference cell "A9" all is well and the formula works. So now I click on the cell and at the bottom right I click on that corner to populate the rest of the cells in that row I do not want the "B4" cell to change in the equation So here is the equation placed in cell B9. =A9-(B4*2) I want the B4 to stay constant and I want the A9 to become A10, a11, A12 ect as I populate that row.

Any Ideas?

TIA

Put $ symbols in the reference to B4 (i.e. $B$4) so that it doesn't change when you copy it (see XL Help on absolute references). If you want A9 to become A10, A11 etc. as you copy ACROSS the sheet, then you will need to do something like this in B9:

=INDEX($A:$A,8+COLUMNS($B:B))-$B$4*2

then copy it across.

Hope this helps.

Pete

Thanks Pete! Solved the issue

Glad to hear it.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete