How do I prevent a formula element from incrementing when copying
 

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.

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.

"Copying Excel Formulas" wrote:

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.

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.


"Copying Excel Formulas" wrote:

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.

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.

"Mike" wrote:

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.

"Copying Excel Formulas" wrote:

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.