View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bella393
 
Posts: n/a
Default How do I add to figures already in a cell?


I have a long pricelist of items that I offer for wholesale. There are
over 5000 items and the prices were just recent raised. I want each
item to reflect the price increase of $20,but I dont want to have to
sit there are edit each and every cell. I have 3 cells going across,
reflectin different prices for different quantities of the same item,
so if I do each one by one, that is 15000 edits I have to do manually.


I would like to add the $20 increase to each cell but do it for all the
cells at once with a formula. If this is possible please let me know.
Any help is appreciated!


--
bella393
------------------------------------------------------------------------
bella393's Profile: http://www.excelforum.com/member.php...o&userid=30744
View this thread: http://www.excelforum.com/showthread...hreadid=504109