for example

i want

A1 to be = G1 (but i want to write G1 in terms of B1+value in the cell 5 columns away)

and then
A2 = G2 (but i want to write G2 in terms of B2+value in the cell 5 columns away)

and then i will drag it down for many many rows

thank you

Could you provide a small example sheet please, I do not understand your query ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

alright, here's the thing.

in column A

in A1, the formula i put is =200*B1
in A2, the formula is =200*H1
in A3, =200*O1
A4, = 200*U1

the sequence here is that from B1 to H1 to O1 to U1... are all 6 horizontal cells away each.

how to i do it? what formula do i put in column A

Thank you

Between B and H there are 5 columns
between H and O there are 6 columns
between O and U there are 5 columns

If the 5 column interval is what you need, try in A1 and pull down as needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post