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

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
 
G

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
 
T

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.
 
P

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
 
T

trip_to_tokyo

sorry I 1 should read:-

=(H1*10%)

Apologies for error.

Please hit Yes if my comments have helped.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top