View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Increasing all values in spreadsheet by same percentage.

Say you want to increase a range of numbers by 38%

Put 1.38
in an empty cell
Edit|copy (that cell)

Select the range to adjust
Edit|Paste special|check Multiply and Values
Then clean up that cell with the 1.38 in it.

Excels Alot wrote:

I would like to know a simple way to increase all values in data cells by the
same percentage. I can't figure out how to write the formula that will
increase the value and add it it the current number in each cell of the
spreadsheet.


--

Dave Peterson