formula in the same cell?

[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

 

[Dan E]

Nycole,

Your first value is in B5 so in C5 put
=B5*110%
Drag down

Dan E

 

[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.

 

[Nycole]

Thank you for your help. That was exactly what I was looking for. Thanks again.