Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
single cell formula
I am working with Excel 2003. I have a worksheet that I can not change the
layout of the worksheet but I need to increase the value of some of the cells in column C by a percent. all of the values are different but the persent will be the same. Is there a formula that I can use to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
single cell formula
Is there a pattern to the cell location. Details?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Ronda" wrote in message ... I am working with Excel 2003. I have a worksheet that I can not change the layout of the worksheet but I need to increase the value of some of the cells in column C by a percent. all of the values are different but the persent will be the same. Is there a formula that I can use to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
single cell formula
If it's a one time, irrevocable change, the you can enter (1+percentage)
somewhere, select the cell, copy, then highlight the range of cells you want to change: Edit: Paste Special: Multiply -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Ronda" wrote: I am working with Excel 2003. I have a worksheet that I can not change the layout of the worksheet but I need to increase the value of some of the cells in column C by a percent. all of the values are different but the persent will be the same. Is there a formula that I can use to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
single cell formula
Cell location will always be in column c but not all cells will be udated in
column c. THere will be a "block of cells updated in that column "Don Guillett" wrote: Is there a pattern to the cell location. Details? -- Don Guillett Microsoft MVP Excel SalesAid Software "Ronda" wrote in message ... I am working with Excel 2003. I have a worksheet that I can not change the layout of the worksheet but I need to increase the value of some of the cells in column C by a percent. all of the values are different but the persent will be the same. Is there a formula that I can use to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula from a single cell to a merged cell | Excel Discussion (Misc queries) | |||
Excel Formula for Single Cell Adress | Excel Worksheet Functions | |||
Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
single cell formula | New Users to Excel | |||
How do I put more than 7 IF formula in a single cell? | Excel Worksheet Functions |