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
|