trouble with copying a cell to other cells.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Info adds +1 (so 3oo goes to 301) and in the same function, 2 stays a 2 when
copied to another cell. How do I mark what changes and what doesn't?
 
I found the info posted on a different post.
by BenjieLop
for Copying a formula 9/20/2004

I want to copy a formula from one cell to several others, it is a basic
formula =c5*d12 when i copy and paste the formula changes..( =c6*d13
and so on...) I want the second part d12 to change but i want to anchor the
first part somehow so the c5 is constant in every formula c5*d13 c5*d14
etc..



The formula

=$C$5*D12

will do the trick
 
You want to use absolute references to *not* change when being copied.

=$C$5*D12

The dollar signs denote "Absolute" cell references, which prevent the cell
addresses from changing during a copy procedure.
They can be mixed also:
=C$5*D12
=$C5*D12
Allowing either the column *or* the row to remain static.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I found the info posted on a different post.
by BenjieLop
for Copying a formula 9/20/2004

I want to copy a formula from one cell to several others, it is a basic
formula =c5*d12 when i copy and paste the formula changes..( =c6*d13
and so on...) I want the second part d12 to change but i want to anchor the
first part somehow so the c5 is constant in every formula c5*d13 c5*d14
etc..



The formula

=$C$5*D12

will do the trick
 
Back
Top