Quote:
|
Originally Posted by gellnsh
Hello everyone,
I have a large data base in excel format but the supplier does not have a MSRP (manufacturers suggested retail price) but they do have all of the wholesale prices.
My question:
Is there a function in excel or some other software that would allow me to add for example 20% markup to the wholesale prices. I have over 20,000 products so changing them one by one would be an astronomical job.
Any help or suggestions would be appreciated.
thanks in advance
|
Uhhhmm ... let me give this a stab. Not a trick question, right?
I assume your spreadsheet has a column with the wholesale princes in it. If so, insert a new column beside it or use an empty one off to the far right.
Using this new column, you need to add a formula that adds 20% to each figure. I think a formula like this could work:
=A1*1.2 (where A1 is the cell with your wholesale price and 1.2 is your mark-up)
This formula can then be copied to all your products.
Try that and let us know if there's more to your question than this.
Best,
James @
DVDsPlusMore