Uniform % increase in column.

S

sue2k

Wondering if anyone can help. I'm probably missing something silly bu
I need to increase all the values in a column by a different % ever
month. Is there a way that I can do this in one go rather tha
manually having to calculate the new value?

Thanks

Su
 
F

Frank Kabel

Hi
one way:
- enter for example the value 1.05 (for a 5% increase) in
an empty cell
- copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'

Note: The original values are lost after this procedure
 
L

Leo Heuser

Sue

One way:

If for instance each value must be increased
by 4%, enter 1.04 (104%) in an empty cell.
Copy the cell and select the cells to be increased.
Choose Edit > Paste special and checkmark
"Multiply". OK and <Esc> (to cancel the selection)
 
D

Dave Peterson

Since you have to do this each month, I'd do it this way:

Find two empty cells (I used A1 and A2 in my example).

Put your percentage in A1 (I used 1.05, 5% increase).
put this formula in the other cell (A2 for me) =$a$1

Then copy A2.
select your range in that column and edit|paste special|multiply.

the values or formulas now have *($a$1) appended to them.

I cleared A2 and whenever I want to change my percentage, I can just type that
new percentage in A1 and all my formulas adjust.
 
Top