Copying a formula

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
 
B

BenjieLop

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top