Excel formula question

[LawyerRon]

How can I apply a formula to raise an entire column a certain percentage? Eg, suppose I have Column "C" that has 1000 entries with various costs of parts. Further suppose I want to increase the "cost" of the entire column by, say, 3%. What formula would I use to effect the entire column accordingly?

[demandred55]

Do you want to raise the values in that column, or create a column next to it that has 3% higher values?

[LawyerRon]

I just want to raise the value of the column by a percentage. I know how to create the column next to it, and then raise the new column, but I don't know how to simply increase a column by a percentage (if that is even possible in excel).

[demandred55]

It may be possible, but I don't think so.

Why not create the new column, then hide the old one?

[LawyerRon]

"Why not create the new column, then hide the old one?"

Yeah, that sounds like the easiest way to do it. Thanks.

[Trent Steel]

From your example I don't completly understand what you want to do. Do you want to change the values of the entries once, or have it so that you simply change the percentage and get new values (ie many changes). I have a solution that should work for you if its a one time change, and will work for multiple changes but is a bit crued for frequent changes.
Okay first you need to create that new column, applying what ever formula you want eg in cell C1 you would put =B1*1.03 where the column B is where your original data is. Then you use the fill command for the remainder of your data entries. Now all you do is copy and paste special (values only) into the old column then you can delete that new column. Repeat as needed.

[LawyerRon]

Thanks Trent, I think your idea will work just fine.

[MadMax]

Another way to make things more automated is to:

Move the contents of column C to an off screen column, say column T.

Next choose a cell to to input the per cent as a hard number. Say D1

In cell C1 put the formula =T1*$D$1

Next copy & paste cell C1 to cells C2 thru C999.

Now changing the per cent in D1 will automatically adjust all prices.

The $ is an absolute cell reference. This is so D1 will stay D1 when you paste.

[Statica]

As an addendum, you dont need to copy and paste the formula through all the cells.
Suppose you have cell F1 as your percentage. And your new column is going to be D. Then select (the entire column by clicking on D). In the formula location use:
=C1+(C1*$F$1). Now instead of pressing Enter, press CTRL+Enter. That will use the formula for all the selected cells.