Copying a formula question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zilbandy - 03 Nov 2006 18:55 GMT

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.

Signature

Zilbandy - Tucson, Arizona USA <zil@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reply to this Message

John Wilson - 03 Nov 2006 19:21 GMT

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

>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
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Zilbandy - 03 Nov 2006 19:54 GMT

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

Thank you and thanks to Bernard, too. :)

Signature

Reply to this Message

Bernard Liengme - 03 Nov 2006 19:23 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message