Possible to change/update values in range of cells by X% ? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Tom McLean 1/22/2008 6:11 PM PST   Question   Is it possible to update or change the values in a range of cells by a certain percentage? What I'm trying to do is apply a 10% increase to a column of prices (several hundred cells long) without doing it manually one by one or creating a new column (B) that references the values in the first column (A) and then manipulates the values by X%. Basically, I'm supposed to update the price list without changing it's present format. I expect to need to do this again in the future several times and it would be wonderful if there was some way to do it quickly and easily. Thanks for any ideas!! Tom     Was this post helpful to you?         Reply |   Top           Jim Cone 1/22/2008 8:50 PM PST   Answer   Enter 1.1 in a blank cell. Copy the cell. Select the column of prices. Go to... Edit (menu) | Paste Special | Multiply (button) - click Ok. Press the Escape key. Delete 1.1 in the blank cell. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tom McLean" wrote in message Is it possible to update or change the values in a range of cells by a certain percentage? What I'm trying to do is apply a 10% increase to a column of prices (several hundred cells long) without doing it manually one by one or creating a new column (B) that references the values in the first column (A) and then manipulates the values by X%. Basically, I'm supposed to update the price list without changing it's present format. I expect to need to do this again in the future several times and it would be wonderful if there was some way to do it quickly and easily. Thanks for any ideas!! Tom     Was this post helpful to you?         Reply |   Top           Tom McLean 1/22/2008 9:53 PM PST   Jim, Thanks VERY much for this quick tip. You solution is both simple and elegant in its implementation! --Tom "Jim Cone" wrote: > > Enter 1.1 in a blank cell. > Copy the cell. > Select the column of prices. > Go to... Edit (menu) | Paste Special | Multiply (button) - click Ok. > Press the Escape key. > Delete 1.1 in the blank cell. > -- > Jim Cone > San Francisco, USA > http://www.realezsites.com/bus/primitivesoftware > (Excel Add-ins / Excel Programming) > > > "Tom McLean" > wrote in message > Is it possible to update or change the values in a range of cells by a > certain percentage? What I'm trying to do is apply a 10% increase to a column > of prices (several hundred cells long) without doing it manually one by one > or creating a new column (B) that references the values in the first column > (A) and then manipulates the values by X%. > > Basically, I'm supposed to update the price list without changing it's > present format. I expect to need to do this again in the future several times > and it would be wonderful if there was some way to do it quickly and easily. > > Thanks for any ideas!! > Tom >     Was this post helpful to you?         Reply |   Top           Bluesman 1/28/2009 2:24 PM PST   Jim, I have the exact same task as Tom. The only difference is that I need to change column totals by 15%. I tried to follow along with the example you gave Tom but unfortunately I don't have the multiplication option in the "paste special" I am using excel 2003. Help!!!! Lee "Jim Cone" wrote: > > Enter 1.1 in a blank cell. > Copy the cell. > Select the column of prices. > Go to... Edit (menu) | Paste Special | Multiply (button) - click Ok. > Press the Escape key. > Delete 1.1 in the blank cell. > -- > Jim Cone > San Francisco, USA > http://www.realezsites.com/bus/primitivesoftware > (Excel Add-ins / Excel Programming) > > > "Tom McLean" > wrote in message > Is it possible to update or change the values in a range of cells by a > certain percentage? What I'm trying to do is apply a 10% increase to a column > of prices (several hundred cells long) without doing it manually one by one > or creating a new column (B) that references the values in the first column > (A) and then manipulates the values by X%. > > Basically, I'm supposed to update the price list without changing it's > present format. I expect to need to do this again in the future several times > and it would be wonderful if there was some way to do it quickly and easily. > > Thanks for any ideas!! > Tom >     Was this post helpful to you?         Reply |   Top           smartin 1/28/2009 3:34 PM PST   Bluesman wrote: > Jim, > > I have the exact same task as Tom. The only difference is that I need to > change column totals by 15%. I tried to follow along with the example you > gave Tom but unfortunately I don't have the multiplication option in the > "paste special" I am using excel 2003. > > Help!!!! > Lee Are you sure? This has been around since before E2003. In the Paste Special dialog, "Multiply" is in the 2nd section labeled "Operation".     Was this post helpful to you?         Reply |   Top           Bluesman 1/29/2009 8:41 AM PST   Jim, I got it to work except It only updated my prices by 10% using 1.1 in a blank cell. I couldn't figure out what number to use to get 15% increase in prices. I could really use your help. Lee "smartin" wrote: > Bluesman wrote: > > Jim, > > > > I have the exact same task as Tom. The only difference is that I need to > > change column totals by 15%. I tried to follow along with the example you > > gave Tom but unfortunately I don't have the multiplication option in the > > "paste special" I am using excel 2003. > > > > Help!!!! > > Lee > > Are you sure? This has been around since before E2003. In the Paste > Special dialog, "Multiply" is in the 2nd section labeled "Operation". >     Was this post helpful to you?         Reply |   Top           David Biddulph 1/29/2009 10:58 AM PST   I'm sorry, but your really need to understand basic arithmetic before you start trying to use a tool like Excel. If you don't understand broadly what calculation you are asking Excel to do, you won't know whether you've got the right answer (which generally means that you may not have asked the right question). A percentage is a fraction of one hundred. 10% is 10 divided by 100, and that is represented in the decimal system as 0.1. If you want to increase a number by 10%, you want to add 10% of the original number to the original number. Hence you need to multiply the original number by 0.1, and add that to the original number. That is the same as multiplying the original number by 1.1. [... as 1 + 0.1 = 1.1] Now try doing the same with your 15%. I would heartily recommend that you find a night-school class or something similar on basic arithmetic before you try to do too much more with Excel. Good luck! -- David Biddulph "Bluesman" <Bluesman@discussions.microsoft.com> wrote in message news:FEFBC1C9-FB67-4964-9664-943E336F8331@microsoft.com... > Jim, > > I got it to work except It only updated my prices by 10% using 1.1 in a > blank cell. I couldn't figure out what number to use to get 15% increase > in > prices. I could really use your help. > Lee > > "smartin" wrote: > >> Bluesman wrote: >> > Jim, >> > >> > I have the exact same task as Tom. The only difference is that I need >> > to >> > change column totals by 15%. I tried to follow along with the example >> > you >> > gave Tom but unfortunately I don't have the multiplication option in >> > the >> > "paste special" I am using excel 2003. >> > >> > Help!!!! >> > Lee >> >> Are you sure? This has been around since before E2003. In the Paste >> Special dialog, "Multiply" is in the 2nd section labeled "Operation". >>     Was this post helpful to you?         Reply |   Top           Bluesman 1/29/2009 12:23 PM PST   David, Thanks for taking the time to explain this to me. Math has never been my cup of tea. Sadly, I have a Masters degree in Counseling. This little project that I am working on is to update prices on my website for my newly acquired online business. I do wish I had the time to take classes but with a wife 2 kids and commuting more than 2.5 hours from home(there and back), there is just no time. If I did the calculation correct I get 1.15 for 15% Lee "David Biddulph" wrote: > I'm sorry, but your really need to understand basic arithmetic before you > start trying to use a tool like Excel. If you don't understand broadly what > calculation you are asking Excel to do, you won't know whether you've got > the right answer (which generally means that you may not have asked the > right question). > > A percentage is a fraction of one hundred. > 10% is 10 divided by 100, and that is represented in the decimal system as > 0.1. > If you want to increase a number by 10%, you want to add 10% of the original > number to the original number. > Hence you need to multiply the original number by 0.1, and add that to the > original number. > That is the same as multiplying the original number by 1.1. [... as 1 + 0.1 > = 1.1] > > Now try doing the same with your 15%. > > I would heartily recommend that you find a night-school class or something > similar on basic arithmetic before you try to do too much more with Excel. > > Good luck! > -- > David Biddulph > > > "Bluesman" <Bluesman@discussions.microsoft.com> wrote in message > news:FEFBC1C9-FB67-4964-9664-943E336F8331@microsoft.com... > > Jim, > > > > I got it to work except It only updated my prices by 10% using 1.1 in a > > blank cell. I couldn't figure out what number to use to get 15% increase > > in > > prices. I could really use your help. > > Lee > > > > "smartin" wrote: > > > >> Bluesman wrote: > >> > Jim, > >> > > >> > I have the exact same task as Tom. The only difference is that I need > >> > to > >> > change column totals by 15%. I tried to follow along with the example > >> > you > >> > gave Tom but unfortunately I don't have the multiplication option in > >> > the > >> > "paste special" I am using excel 2003. > >> > > >> > Help!!!! > >> > Lee > >> > >> Are you sure? This has been around since before E2003. In the Paste > >> Special dialog, "Multiply" is in the 2nd section labeled "Operation". > >> > > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies