![]() |
looking to update price list, wanted to up charge list by 35% .
was looking to change our price list w/o having to manuel change the
database for each item. How do i add percentage formulas to colunms of existing prices in excel |
For me - I do this thus:
Into an empty cell type in the increase I want in the form where 1.15 = 15% or 1.30 = 30%. I thn copy this value. I then select everything I want to bump up and choose paste special - multiply. ttfn benm |
Hi Frankie,
If the increase is all the same percentage, place it in an empty cell and copy it. Select all of your existing prices and choose Edit, Paste Special, Multiply. "frankie" wrote: was looking to change our price list w/o having to manuel change the database for each item. How do i add percentage formulas to colunms of existing prices in excel |
All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com