Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Moving columns with VLOOKUP formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |