Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to increase all numbers in a worksheet by the same percenta
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 On Sep 11, 1:22 am, Belle wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I increase numbers by 10%, 15% and 20%? | Excel Discussion (Misc queries) | |||
Increase group of numbers by same amount | Excel Worksheet Functions | |||
How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
can I increase excel column numbers to more than 256? | Excel Discussion (Misc queries) | |||
Increase numbers in cells | Excel Discussion (Misc queries) |