Increase numbers by 15% in multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much appreciated.
 
enter 115% in a free cell
copy that cell
select all the cells to multiply by
goto menu Edit>PasteSpecial
select Multiply
OK
clear the cell with 115% in it

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
One way:

Enter 1.15 in an empty cell. Copy the cell. Select the cells to increase
the value. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons.
 
Place 1.15 into any empty cell. Copy that cell. Select the cells you want to
increase and then Paste Special -> Choose Multiply...
 

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

Similar Threads

consecutive numbering on multiple worksheets 2
Maximum amount of numbers in one Cell 2
Increase A2 by 15% 2
formula to subtract percentage from whole 2
counting text same cell multiple worksheets 11
increasing amounts in cells automatically 2
increase cell value 1
Counting multiple memberships 1

Back
Top