Thread: Moving formulas
View Single Post
  #1   Report Post  
Chris White feeling dumb!
 
Posts: n/a
Default Moving formulas

Hi this is stupid I've done it before, but now can't get it right.
I want to create a formula that adds 2% to a whole range of fields.
if I use for example =sum(c2)+(c2*0.02) and try to put that in cell c2 it
says circle no allowed. if I put this formula in say d3 no prob and I can
move the formula down in the D column and the c2 goes c3,c4,c5 etc. but I
don't want to use a new column.. help please
Chris

auto reply won't work as it's a hotmail and I don't use that really