View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rebecca
 
Posts: n/a
Default 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).