how do I add 3% or 5 % to a column
 

I need to add a percentage to a column for my price list .
Can someone please help me

how do I add 3% or 5 % to a column
 

Put 1.03 (or 1.05) in an empty cell.
Edit|copy that cell
Select the range to adjust.
edit|paste special|choose multiply and values

Clean up that cell with 1.03/1.05 in it.

Sue wrote:

I need to add a percentage to a column for my price list .
Can someone please help me

--

Dave Peterson

how do I add 3% or 5 % to a column
 

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto EditPaste special and select Multiply. you can delete the 1.03 and change
it to 1.05
and do the same thing again for your other range.
HTH
John
"Sue" wrote in message
...
I need to add a percentage to a column for my price list .
Can someone please help me

how do I add 3% or 5 % to a column
 

In cell A 1 I have 100

In cell B 1 I have 0.03

In cell C 1 I have:-

=(A1*B1)+A1

- giving a result of 103 in cell C 1

If my comments have helped please hit Yes.

Thanks.

"Sue" wrote:

I need to add a percentage to a column for my price list .
Can someone please help me

drag formula to a column
 

Hello!

if you want to add 3% or 5% to a column, first, we'll name the base column as Column A, then if we want to add 3% to 5% on to column A, we just need to put 1.03 or 1.05 to a random cell, Z1. Now, we can place a formula on another column, B, and use the formula:

=A*Z1

on Column B, and just drag it until the last entry of the column A. now we get a 3% increase for all the entries in Column A which are in Column B.

For more tips on excel and Financial Models, you can check this out. Hope this Helps!