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 |
#2
|
|||
|
|||
Type 102% in an empty cell, then copy that cell
Select all the cells to increase, then menu EditPasteSpecial and choose the Multiply option from the Operation section. OK out. -- HTH Bob Phillips "Chris White feeling dumb!" <Chris White feeling wrote in message ... 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 |
#3
|
|||
|
|||
Well not quite but with your help it works if you type 1.02 then multiply
with that, if you put 102% it does some wierd and wackey results, but the greatest help was the paste special multiply. thanks "Bob Phillips" wrote: Type 102% in an empty cell, then copy that cell Select all the cells to increase, then menu EditPasteSpecial and choose the Multiply option from the Operation section. OK out. -- HTH Bob Phillips "Chris White feeling dumb!" <Chris White feeling wrote in message ... 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 |
#4
|
|||
|
|||
"Chris White feeling not quite as dumb!" <Chris White feeling not quite as wrote in message ... Well not quite but with your help it works if you type 1.02 then multiply with that, if you put 102% it does some wierd and wackey results, Don't know what wierd and wackey results you get, but it worked fine for me, with 102%. |
Reply |
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 |