Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
I have Office XP. In Excel I want to increase the price in the whole column
by lets say 5% how do I do it? Sol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
If you want another column with the new values:
Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
For example in row 1 the amount is $10.00 and I want to increase it by 5% to
$10.50, and row 2 the amount is $15.00 I want to increase by 5% to $15.75, and row 3 the amount is $20.00 and I want to increase by 5% to $21.00, etc. "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
So use either method I gave you
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... For example in row 1 the amount is $10.00 and I want to increase it by 5% to $10.50, and row 2 the amount is $15.00 I want to increase by 5% to $15.75, and row 3 the amount is $20.00 and I want to increase by 5% to $21.00, etc. "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
Thank You. I am trying to change all rows in column N. How do I do it?
"Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
Thank You. When I go to Paste special I do not find an option Multiply. Also
am trying to change all rows in column N. How do I do it? Sol "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
What options do you see under Paste Special?
Multiply will be top right option under "Operation" First copy the cell with 1.05 Then select the range in column N and EditPaste SpecialMultiplyOK Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 11:47:25 -0400, "S1L1Y1" wrote: Thank You. When I go to Paste special I do not find an option Multiply. Also am trying to change all rows in column N. How do I do it? Sol "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
Thanks, It says source and gives a choose paste as Unicode Text, or text.
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... What options do you see under Paste Special? Multiply will be top right option under "Operation" First copy the cell with 1.05 Then select the range in column N and EditPaste SpecialMultiplyOK Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 11:47:25 -0400, "S1L1Y1" wrote: Thank You. When I go to Paste special I do not find an option Multiply. Also am trying to change all rows in column N. How do I do it? Sol "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Same in amount in whole Column
From where are you copying?
Same workbook and sheet? The behaviour you describe is indicative of having two workbooks open in 2 separate instances of Excel and you are copying from one to the other. Gord On Wed, 19 Aug 2009 14:35:43 -0400, "S1L1Y1" wrote: Thanks, It says source and gives a choose paste as Unicode Text, or text. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . What options do you see under Paste Special? Multiply will be top right option under "Operation" First copy the cell with 1.05 Then select the range in column N and EditPaste SpecialMultiplyOK Gord Dibben MS Excel MVP On Wed, 19 Aug 2009 11:47:25 -0400, "S1L1Y1" wrote: Thank You. When I go to Paste special I do not find an option Multiply. Also am trying to change all rows in column N. How do I do it? Sol "Bernard Liengme" wrote in message ... If you want another column with the new values: Suppose first old value is in A1, then in B1 enter =A1*1.05 Drag this down the column If you want to alter the original data In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays as 105.00%) Copy this cell Select the column of data Use Edit | Paste Special with Multiply specified Now you can delete the 1.05 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "S1L1Y1" wrote in message ... I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get last amount in a column | Excel Worksheet Functions | |||
enter date in column a and amount in column d | Excel Discussion (Misc queries) | |||
Insert Row When Column Amount Changes | Excel Discussion (Misc queries) | |||
Insert Row When Column Amount Changes | New Users to Excel | |||
Insert New Row When Column Amount Changes | Excel Worksheet Functions |