Percentage calculation

  • Thread starter Thread starter Daniel Louwrens
  • Start date Start date
D

Daniel Louwrens

I have a spreadsheet with several columns and cells with values which I need
to increase by 20%.
How do I do that all at the same time.

thanks

Daniel
 
Daniel,

Put 1.2 in a cell, copy it. Select the cells to be increased. Edit - Paste
Special - Multiply. Trash the 1.2 cell.
 
Put 1.2 in a cell.
Select that Cell and Right Click Copy
Highlight the data you want to increase. Right Click, Paste Special,
Operation -Click Multiply then OK.
 
It is so simple it is embarrasing,
than you both for your help

regards

Daniel
 
Back
Top