Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in Excel XP
Trying to insert a 5% price increase into a range of cells. I.e. - customer
price list will recieve a 5% increase... Is there any way to to insert a formula into a range of cells or do you "paste & copy" the formula into each individual cell (what I am doing now). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in Excel XP
Put the number 1.05 into a cell that you are not currently using. Copy the
cell. Highlight the range of cells that you would like to apply the 5% increase to. Click on Edit -- Past Special... -- Choose Multiply from the operation section. Click OK. - Search "Rebecca" wrote: Trying to insert a 5% price increase into a range of cells. I.e. - customer price list will recieve a 5% increase... Is there any way to to insert a formula into a range of cells or do you "paste & copy" the formula into each individual cell (what I am doing now). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in Excel XP
If you are going to increase a value with 5% you can do as follows,
put 1.05 in an empty cell, copy it (ctrl + C or editcopy), select the list you want to change and do editpaste special and select multiply You might want to backup your data first -- Regards, Peo Sjoblom "Rebecca" wrote in message ... Trying to insert a 5% price increase into a range of cells. I.e. - customer price list will recieve a 5% increase... Is there any way to to insert a formula into a range of cells or do you "paste & copy" the formula into each individual cell (what I am doing now). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in Excel XP
Thank You - Thank You - Thank You
"Search33" wrote: Put the number 1.05 into a cell that you are not currently using. Copy the cell. Highlight the range of cells that you would like to apply the 5% increase to. Click on Edit -- Past Special... -- Choose Multiply from the operation section. Click OK. - Search "Rebecca" wrote: Trying to insert a 5% price increase into a range of cells. I.e. - customer price list will recieve a 5% increase... Is there any way to to insert a formula into a range of cells or do you "paste & copy" the formula into each individual cell (what I am doing now). |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas in Excel XP
Thank You so much!!
"Peo Sjoblom" wrote: If you are going to increase a value with 5% you can do as follows, put 1.05 in an empty cell, copy it (ctrl + C or editcopy), select the list you want to change and do editpaste special and select multiply You might want to backup your data first -- Regards, Peo Sjoblom "Rebecca" wrote in message ... Trying to insert a 5% price increase into a range of cells. I.e. - customer price list will recieve a 5% increase... Is there any way to to insert a formula into a range of cells or do you "paste & copy" the formula into each individual cell (what I am doing now). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |