how do i increase the value of numbers in a column by a percentage

[colinchurcher]

i have an excel stocklist with 6000 items on it ,i just need to know how to
increase the whole price list column by a percentage , thanks

 

[Gary''s Student]

Say we want to increase a column of values by 6%. In an unused cell, enter
1.06. Copy this cell. Select the column of numbers. PasteSpecial > Multiply

 

[trip_to_tokyo]

1. In cell H 1 I have:-

10

2. In cell I 1 I have:-

=(H1*10%)

3. Just copy the formula above down the column:-

- Ctrl-C in cell I 1

- highlight cells I 2 to I 6000

- Ctrl-V to paste.

The above should achieve what you want.

If my comments have helped please hit Yes.

Thanks.

 

[Per Jessen]

Say you want to add 10% to all prices, then enter 1,1 in an unused cell,
copy the cell, then select the price column, and goto Edit > PasteSpecial >
Operation: Multiply.

Regards,
Per

 

[trip_to_tokyo]

sorry I 1 should read:-

=(H1*10%)

Apologies for error.

Please hit Yes if my comments have helped.

Thanks.

 

[Gord Dibben]

Keep at it. You'll get it right eventually<g>


Gord Dibben MS Excel MVP