Increasing cell value by a percentage

S

Shaun

Hi again,
Another request, how would I increase the numerical value
amount of each individual cell in a column by 20% - NOT
add them all up and increase to total by 20%

Thanks - Shaun
 
K

Ken Wright

Put 1.2 in a blank cell and then copy it. Select all your data and then do Edit / Paste Special /
Multiply.
 
L

Leo Heuser

Hi Shaun

1. Enter 1.2 in a cell, e.g. H34
2. Select H34 and copy it (<Ctrl>c for instance)
3. Select the column.
4. Choose Edit > Paste special and choose "Multiply" OK.
5. <Esc> (to cancel the selection)


--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Top