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
--
Gary''s Student - gsnu200909


"colinchurcher" wrote:

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

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.



"colinchurcher" wrote:

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

"colinchurcher" skrev i
meddelelsen ...
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

sorry I 1 should read:-

=(H1*10%)

Apologies for error.

Please hit Yes if my comments have helped.

Thanks.



"colinchurcher" wrote:

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

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


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 09:39:01 -0800, trip_to_tokyo
wrote:

sorry I 1 should read:-

=(H1*10%)

Apologies for error.

Please hit Yes if my comments have helped.

Thanks.



"colinchurcher" wrote:

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