Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i increase the value of numbers in a column by a percentage
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase whole column by same percentage | Excel Discussion (Misc queries) | |||
How to increase the value of a whole column of cells by a percentage? | Excel Discussion (Misc queries) | |||
How to increase the value of a whole column of cells by a percentage? | Excel Discussion (Misc queries) | |||
How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
increase all values in a column by a percentage | Excel Worksheet Functions |