looking to update price list, wanted to up charge list by 35% .

[Guest]

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

 

[Ben McBen]

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

 

[Guest]

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.