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

[Sue]

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

 

[Dave Peterson]

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.

 

[John]

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto Edit>Paste 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

 

[trip_to_tokyo]

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.