copying and pasting excel formulae

  • Thread starter Thread starter bennyrub
  • Start date Start date
B

bennyrub

I have a worksheet of cash figures that I need t o show a 3%, $% & 5%
increase. I devised a formula =Sum(C1)*B2/100+B2 which i then wanted to copy
and paste down. But how can i copy and paste the formula so that (C1 remains
constant whilst the B numbers increase chronologically. please help URGENT
 
hi,
use absolute reference at C1. $C$1
with out the dollar signs are reletive references and will change reletive
tn where you paste.

regards
FSt1
 
Thanks a lot
hi,
use absolute reference at C1. $C$1
with out the dollar signs are reletive references and will change reletive
tn where you paste.

regards
FSt1
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Copy Excel functions formula and auto refresh refresh 3
Scrabble Value calculation for Welsh words 0
COPYING FORMULAE 1
Formula correction 1
Copying formulas across columns 2
FOrmula Copy and Paste 3
Copy Data from One Spreadsheet to Another ?????? 5
Extract Formula to Text 6

Back
Top