formula in the same cell?

N

Nycole

I have a value in a cell (B5)$3.39. I would like to add 10% to it.
How do I do that? and than still be able to copy the formula to 100
other cells? I can get it by 3.39*10%+3.39 but I would like to be
able to just type in one formula and copy it to the rest. The other
99 cells all have different numbers. Please help
 
J

J.E. McGimpsey

If you want to add 10% to each cell, put 1.1 in a blank cell. Copy
the cell. Select your 100 cells and choose Edit/Paste Special,
selecting the Value and Multiply radio buttons, then click OK. Clear
the cell that you entered 1.1 in.
 
Top