I need to increase all numbers in a worksheet by the same percenta

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have columns of numbers like so:
(just straight numbers no forumlas)

A B C
171.60 166.40 111.38
150.80 146.64 117.29
119.60 116.48 111.28

I just need to increase each number by 2.45% (or a set percentage) - how do
I do this? and have the ability to update this later.
At the moment I am inserting another column and using a formula like
=(A1*.245)+A1 then hiding the original column.

Please help! Thanks!
 
In a blank cell somewhere (eg E1) enter 1.0245, then select that cell
and click <copy>. Then highlight all the cells that you want to
increase (A1:C3 in your example) and Edit | Paste Special | Multiply
(check) | OK and then <Esc>.

All your numbers will be increased by 2.45%.

To get back to your original numbers repeat but check the Divide
operation. To increase by a different percentage (eg. 3.21%), just
change the original number to (eg) 1.0321.

Hope this helps.

Pete
 
Back
Top