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

  • Thread starter Thread starter colinchurcher
  • Start date Start date
C

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
 
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
 
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.
 
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
 
sorry I 1 should read:-

=(H1*10%)

Apologies for error.

Please hit Yes if my comments have helped.

Thanks.
 
Back
Top