formula in the same cell?

  • Thread starter Thread starter Nycole
  • Start date Start date
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
 
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.
 
Back
Top