changing column number in formula automatically

[Legacy 69493]

Thanks for your help in creating an IF statement but now I would like to change the column numbers automatically and have the formula in every column.

ie. =If(O32="G",N32*0.06,"")
then I want this to change to
=IF(O33="G",N33*0.06,"")

Is there a way of having the column numbers change automatically in every column so that I don't have to enter this to over 200 columns?

Thanks

 

[moneytastesbad]

Have you tried coping and pasting?

The formulas should automaticly update

 

[Andrew Poulsom]

That's changing row numbers isn't it? Do you want them to increase when you copy the formula across columns?

=IF(INDEX($O:$O,COLUMN(A1)-COLUMN($A1)+ROW(O32))="G",INDEX($N:$N,COLUMN(A1)-COLUMN($A1)+ROW(N32))*0.06,"")

 

[Legacy 69493]

Thank you for your suggestions.

Yes it is the row numbers that I want to advance as I am trying to get a bunch of items to calculate GST if they have GST applied. I have a column with G in it to state wether it does or not.

Coping does not get it to advance to row numbers with it and the other formula from andrew I don't understand enough but when I tried it it didn't work.

 

[Andrew Poulsom]

It worked when I tried it. In what way didn't it work for you?

 

[Pekkavee]

Do you have any "$" signs in your formula?

Take them away.

Then it will work when copying.

Pekka

 

[Legacy 69493]

Sorry taking out the "$" didn't work either.

How it didn't work was it calculated nothing in all the rows including when their was a "G" in the line to calculate GST.

Thanks for everyones suggestions.

 

[Pekkavee]

Maybe you have an extra space in those cells.

G + space.

Try just put a "G" in there
If it works, then you can use TRIM formula to get rid of spaces.

Pekka

PS. What are your formulas in those other cells after taking "$" signs away from the first cell and copying it to other cells.?

 

[Legacy 69493]

I tried this formula.

=IF(INDEX(O:O,COLUMN(A1)-COLUMN(A1)+ROW(O32))="G",INDEX(N:N,COLUMN(A1)-COLUMN(A1)+ROW(N32))*0.06,"")

I don't think their are extra spaces I cut and pasted andrews formula.

 

[Pekkavee]

I tried this formula.

=IF(INDEX(O:O,COLUMN(A1)-COLUMN(A1)+ROW(O32))="G",INDEX(N:N,COLUMN(A1)-COLUMN(A1)+ROW(N32))*0.06,"")

I don't think their are extra spaces I cut and pasted andrews formula.

I think your own formula should work in this case when copied without "$" signs

Pekka