Increasing all values in spreadsheet by same percentage.

  • Thread starter Thread starter Excels Alot
  • Start date Start date
E

Excels Alot

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.
 
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.
 
Back
Top