Percentage calculation

  • Thread starter Daniel Louwrens
  • 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
 
E

Earl Kiosterud

Daniel,

Put 1.2 in a cell, copy it. Select the cells to be increased. Edit - Paste
Special - Multiply. Trash the 1.2 cell.
 
D

Dale Hymel

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

Daniel Louwrens

It is so simple it is embarrasing,
than you both for your help

regards

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top