Copying a formula while leaving one cell fixed

  • Thread starter Thread starter FSPH
  • Start date Start date
F

FSPH

Hi there,

I forgot how to leave one cell fixed while copying a formula down a column.

For example,
"=RC[-3]*R[-45]C[-5]"
should read
"=RC[-3]*R[-46]C[-5]"

I recall using a Dollar sign ("$") to hardwire a cell in a formula. My
formula should then read "=RC[-3]*$R9$C3"

However, this doesn't seem to work.

Thank you for your help.
 
You can use the $ to fix the row or column -- but only if you're using A1
reference style.

If you're using R1C1 reference style, then this:

=RC3*R[-45]C5
would take the value in column C of the same row (RC3) and subtract the value in
the row 45 rows above it, but in column E (r[-45]c5)

So maybe you want:

=RC[-3]*R9C3

(R9C3 is the same as $C$9 in A1 reference style)

Hi there,

I forgot how to leave one cell fixed while copying a formula down a column.

For example,
"=RC[-3]*R[-45]C[-5]"
should read
"=RC[-3]*R[-46]C[-5]"

I recall using a Dollar sign ("$") to hardwire a cell in a formula. My
formula should then read "=RC[-3]*$R9$C3"

However, this doesn't seem to work.

Thank you for your help.
Click to expand...
 
Back
Top