View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Belle[_2_] Belle[_2_] is offline
external usenet poster
 
Posts: 8
Default I need to increase all numbers in a worksheet by the same percenta

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!