Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|