Locking column, but not row

Hi all,
What I am trying to do is copy a formula by row and have the following changes.

When I copy the formula across the next formula should be.

=(I34-((E15-408)*1.138))*0.1

and the one after should be

=(I35-((F15-408)*1.138))*0.1

and so on and so forth - so the "i" bit should increase in number i34 - becomes i35

and the "15" bit should increase in letter so "E" becomes "F"

Thanks for changing the title to something more descriptive.

The formula

=COLUMN(AH1)

will return the number 34. Copied across, it will increment to 35, 36, etc.

So you could use something like

=(INDIRECT("I"&COLUMN(AH1))-((E15-408)*1.138))*0.1

When copied across, the next cell to the right will show

=(INDIRECT("I"&COLUMN(AI1))-((F15-408)*1.138))*0.1
=(INDIRECT("I"&COLUMN(AJ1))-((G15-408)*1.138))*0.1

etc.

cheers,

I take it that "man" covers all kinds of genders and aliens. Thanks for the feedback.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save