How do I prevent a formula element from incrementing when copying

  • Thread starter Copying Excel Formulas
  • Start date
C

Copying Excel Formulas

Is there a way to prevent a field in a formula from incrementing when the
formula is copied to other cells? For example: In the formula
=PRODUCT(C3,A28), I do not want the A28 to change when I copy the formula to
ten other cells.
 
M

Mike

There is no easy way. If A28 never changes then just enter the number in the
formula. Or copy A28 to the ten cells left or down.
 
R

Robbo

Use the $ sign before the row and column:

=PRODUCT(C3,$A$28)

This will mean that the 'A28' part will stay the same where-ever you move
it. Alternatively if you want the row to change, you can use $A28, or if you
want the column to change, you can use A$28.
 
C

Copying Excel Formulas

I found out from another responder that if you write the A28 as $A$28, the
value will not change as it's copied to other cells. I tried it and it
worked. I just wanted to share this with you.
 
Top