Copying a formula

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

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..

Thank you very much I do appreciate any help you can give.
Bill
 
The formula

=$C$5*D12

will do the trick.

I want to copy a formula from one cell to several others, it is
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 t
anchor the
first part somehow so the c5 is constant in every formula c5*d13
c5*d14
etc..

Thank you very much I do appreciate any help you can give.
Bil
Click to expand...
 
Back
Top