3 Replies Latest reply: Dec 4, 2012 5:06 AM by Wayne Contello
Level 1 (0 points)

Hi, This is my first time I hope someone can help.

I am working with numbers and I have a large number of products in one column and the relevent prices in another. All the prices are different and I want to increase the price of everything by 5% or 10% etc. Is this possible?

Stiffy123

• ###### 1. Re: Hi, I have a large number of products in one column and prices of the products in another. Most prices are different. I want to know if it is possible to increase all of the prices by 5% or 10% etc. Hope someone can help. From Stiffy
Level 6 (13,620 points)

Ad a new, temporary column (or one you can hide when not using). Let's say the current Prices are in column C and the new column is D.

you can inflate the prices in column C by 5% by entering the formula in the first cell of column D as:

=C2*105%

likes this:

to fill down, select D2, then copy, then select the D3 thru the end of the column, then paste.  Now select C2 thru the end of column C, now paste over the existing values using the menu item "Edit > Paste Values"

you can now hide column D until you need to use it again.

• ###### 2. Re: Hi, I have a large number of products in one column and prices of the products in another. Most prices are different. I want to know if it is possible to increase all of the prices by 5% or 10% etc. Hope someone can help. From Stiffy
Level 1 (0 points)

Hi Wayne

Thanks , thats great.