Thread: increase different prices by a certain percentage all at once
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
  
Posts: 2,069
Default increase different prices by a certain percentage all at once
put 1.3 in another cell, copy it and then select the cells to increase by
30%, then editpaste specialmultiply. delete the cell with 1.30 in it
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"budda" wrote:

i want to increase my prices by 30% how can i do it all at once?

Reply With QuoteReply With Quote