View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bennyrub
 
Posts: n/a
Default copying and pasting excel formulae

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