Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to calculate a specific percent of a column of different p
I'm looking for a way to calculate a specific percent of a column of
different prices in different cells. Can anyone assist. I want to reduce the different prices by a specific percentage for about 490 items automaticully. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to calculate a specific percent of a column of different p
Select a new, unused cell and enter the amount to change.
i.e. - to increase 10% - use 1.1 to cut 25% - use 0.75 Then right click in that cell and choose <Copy Select the cells you wish to change, and right click in that selection and choose "Paste Special". Click on "Multiply", then <OK, then <Esc While the cells are *still* selected, you can then format all those cells as you wish. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Steve" wrote in message ... I'm looking for a way to calculate a specific percent of a column of different prices in different cells. Can anyone assist. I want to reduce the different prices by a specific percentage for about 490 items automaticully. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula for percent off of column | New Users to Excel | |||
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? | Excel Worksheet Functions | |||
How to calculate and then show up as a percent? | Excel Worksheet Functions | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
calculate percent increase | Excel Discussion (Misc queries) |