Formula to consecutively move down cells in list

[McDan]

I have a list of data from B1 to B10. I am trying to run a formula across a row where each cell uses the same formula except for a link to the B column that goes down 1 cell for each cell across the row. The formula is in F15 and looks like this:

=((65/10000)*(B1))/1000

I would like it to be the same thing in G15 but have a B2 instead.
(When I use $B1 it keeps $B1 instead of going to B2)

What is the correct input please?

Thanks

 

[jbeaucaire]

Put that original formula in F15.
Now copy that cell DOWN, not to the right to get the new formulas adjusted the way you want.

Now select F16, CUT, and paste into G15, etc...

 

[Marcelo Branco]

Another

Put this formula in F15
=65/10000*INDEX($B$1:$B$10,COLUMNS($F:F))/1000

copy across till O15

M.