ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   incrementing cost in excel??? (https://www.excelbanter.com/new-users-excel/85895-incrementing-cost-excel.html)

cerebro

incrementing cost in excel???
 

Hi, I have a list of wholesale prices for a range of products and I want
to change the price to retail to sell through an ebusiness and was
wondering if I could use excel to increment all the wholesale costs by
say 20 without having to do each by hand. Is it possible to update all
the prices with a few commands or am i going to have to change all 1000
of them by hand. thanks for any help.


--
cerebro
------------------------------------------------------------------------
cerebro's Profile: http://www.excelforum.com/member.php...o&userid=33952
View this thread: http://www.excelforum.com/showthread...hreadid=537274


JE McGimpsey

incrementing cost in excel???
 
Enter 20 in a blank cell. Copy the cell. Select your prices. Choose
Edit/Paste Special, selecting the Values and Add radio buttons. Click OK.

In article ,
cerebro wrote:

Hi, I have a list of wholesale prices for a range of products and I want
to change the price to retail to sell through an ebusiness and was
wondering if I could use excel to increment all the wholesale costs by
say 20 without having to do each by hand. Is it possible to update all
the prices with a few commands or am i going to have to change all 1000
of them by hand. thanks for any help.


cerebro

incrementing cost in excel???
 

thank you very much for a quick response.


--
cerebro
------------------------------------------------------------------------
cerebro's Profile: http://www.excelforum.com/member.php...o&userid=33952
View this thread: http://www.excelforum.com/showthread...hreadid=537274



All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com