How to specify a static cell reference

  • Thread starter Thread starter PRW
  • Start date Start date
P

PRW

Hi,

I'm trying to create a worksheet that calculates the compounding
effect of a specified percentage increase on a given starting figure
i.e. starting with 100 and increasing it in steps by 10% each time.

How do I copy the formula I've created whilst stopping Excel from
automatically changing the reference of the cell containing the
percentage I want to use? I want every formula to refer to cell I4
which contains the percentage I'm using instead of changing it to I5,
I6, I7 etc

To put it another way, how do I tell Excel that one cell referenced in
the formula is not to change whilst the others are?

I hope that makes sense....it's a simple problem but a difficult one
to put into words.

Many thanks

Paul
 
Instead of using I4 in your formula, write it as $I$4 - this is using
absolute references and will not change when you copy the formula
across or down.

Hope this helps.

Pete
 
PRW said:
Hi,

I'm trying to create a worksheet that calculates the compounding
effect of a specified percentage increase on a given starting figure
i.e. starting with 100 and increasing it in steps by 10% each time.

How do I copy the formula I've created whilst stopping Excel from
automatically changing the reference of the cell containing the
percentage I want to use? I want every formula to refer to cell I4
which contains the percentage I'm using instead of changing it to I5,
I6, I7 etc

To put it another way, how do I tell Excel that one cell referenced in
the formula is not to change whilst the others are?

I hope that makes sense....it's a simple problem but a difficult one
to put into words.

Many thanks

Paul

Use an absolute reference: $I$4 instead of I4.
 
Instead of using I4 in your formula, write it as $I$4 - this is using
absolute references and will not change when you copy the formula
across or down.

Hope this helps.

Pete

Brilliant, thanks very much.....I knew it would be something simple.
 
Back
Top