Increasing cell value by a percentage

  • Thread starter Thread starter Shaun
  • Start date Start date
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
 
Put 1.2 in a blank cell and then copy it. Select all your data and then do Edit / Paste Special /
Multiply.
 
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.
 
Back
Top