Increasing all values in spreadsheet by same percentage.
 

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.

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