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