Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
Hello,
I am a novice Excel user trying to tackle the following problem - I have a spreadsheet with about 1500 rows of prices all situated in one column. I would like to apply a certain markup percentage to each item. Is there a formula or some other technique I can use to apply this arbitrary percent (say 20%) to the price column without having to do it line by line? Thanks, Jonny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
Jonny,
Enter 0.20 in some empty cell and copy that. Then select the cells you wish to change. Go to the Edit menu, choose Paste Special, and use the Multiply option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Memphis Slim" wrote in message oups.com... Hello, I am a novice Excel user trying to tackle the following problem - I have a spreadsheet with about 1500 rows of prices all situated in one column. I would like to apply a certain markup percentage to each item. Is there a formula or some other technique I can use to apply this arbitrary percent (say 20%) to the price column without having to do it line by line? Thanks, Jonny |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
I think he meant markup chip
in that case he would want to multiply by 1.20 not 0.20 otherwise he will get a reduction in price. ben "Chip Pearson" wrote: Jonny, Enter 0.20 in some empty cell and copy that. Then select the cells you wish to change. Go to the Edit menu, choose Paste Special, and use the Multiply option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Memphis Slim" wrote in message oups.com... Hello, I am a novice Excel user trying to tackle the following problem - I have a spreadsheet with about 1500 rows of prices all situated in one column. I would like to apply a certain markup percentage to each item. Is there a formula or some other technique I can use to apply this arbitrary percent (say 20%) to the price column without having to do it line by line? Thanks, Jonny |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
Yeah, I missed that.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ben" wrote in message ... I think he meant markup chip in that case he would want to multiply by 1.20 not 0.20 otherwise he will get a reduction in price. ben "Chip Pearson" wrote: Jonny, Enter 0.20 in some empty cell and copy that. Then select the cells you wish to change. Go to the Edit menu, choose Paste Special, and use the Multiply option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Memphis Slim" wrote in message oups.com... Hello, I am a novice Excel user trying to tackle the following problem - I have a spreadsheet with about 1500 rows of prices all situated in one column. I would like to apply a certain markup percentage to each item. Is there a formula or some other technique I can use to apply this arbitrary percent (say 20%) to the price column without having to do it line by line? Thanks, Jonny |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
i only noticed cause all i see all day long are prices.
"Chip Pearson" wrote: Yeah, I missed that. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ben" wrote in message ... I think he meant markup chip in that case he would want to multiply by 1.20 not 0.20 otherwise he will get a reduction in price. ben "Chip Pearson" wrote: Jonny, Enter 0.20 in some empty cell and copy that. Then select the cells you wish to change. Go to the Edit menu, choose Paste Special, and use the Multiply option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Memphis Slim" wrote in message oups.com... Hello, I am a novice Excel user trying to tackle the following problem - I have a spreadsheet with about 1500 rows of prices all situated in one column. I would like to apply a certain markup percentage to each item. Is there a formula or some other technique I can use to apply this arbitrary percent (say 20%) to the price column without having to do it line by line? Thanks, Jonny |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating percentage throughout a column
Chip & Ben,
Thank you so much. You saved me hours worth of work!! Jonny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting #DIV/0! when calculating percentage | Excel Worksheet Functions | |||
calculating percentage | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Calculating Percentage | Excel Worksheet Functions | |||
calculating 10 percentage of items in a column | Excel Discussion (Misc queries) |