Copying a formula question

[Zilbandy]

I am a novice Excel user and have a formula I would like to copy to
more than 100 cells in a column. I am hoping there is an easy way to
do this without entering it many times. The pattern of the formulas
are outlined below:

=B6-(B6*B2-A2)/500
=B7-(B7*B2-A2)/500
=B8-(B8*B2-A2)/500
=B9-(B9*B2-A2)/500
=B10-(B10*B2-A2)/500

Thanks.

 

[John Wilson]

Zilbandy,

Use the $ to lock the rows and/or columns
=B6-(B6*$B$2-$A$2)/500

When copied 'down' the column, the B6 will
increment to B7, 8, 9, etc.
The $B$2-$A$2 will not change.

John

 

[Bernard Liengme]

Start with =B6-(B6*$B$2-$A$2)/500
Now when you copy down to the next cell you get
=B7-(B7*$B$2-$A$2)/500
The $ sign may be thought of as the "don't mess with me" symbol !
best wishes

 

[Zilbandy]

Use the $ to lock the rows and/or columns
=B6-(B6*$B$2-$A$2)/500

Thank you and thanks to Bernard, too.