Excel functions??

[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

[DVDsPlusMore]

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

[gellnsh]

Hi James,

YOu could be a godsend. This is exactly what I'm referring to. However, one small problem is I'm not real clear on how to use excel. If you would be so kind as to explain the process in a bit more detail. I tried selecting all of the new column and then entering the suggested formula into the bar at the top and clicking on 'Fx'. Then I get a menu with some choices. I tried 'Sum' but nothing seems to happen. So as you can see I'm not all that familiar with excel.

thanks for your help,
shell

[DVDsPlusMore]

Originally Posted by gellnsh

Well, godsend might be a little over the top ... but hopefully I can get you through this!

1. Identify what column your current wholesale prices are in -- might be "B", "C", or even "AA", "AB", etc. Note also what row your first price is in -- might be "2", "3", etc. For sake of an example, let's assume that these coordinates are "C" and "2" for you.
2. Locate an empty column on the far right of your data. Make sure it's completely empty all the way to the bottom of your data. Again, let's assume this column is "Q" for you.
3. Go to cell "Q2" -- your empty column and on the same row as your first price.
4. Type this formula (no quotes and no spaces) "=C2*1.2" and hit "enter" This will multiply whatever is in "C2" by 1.2. Does the resulting answer look right? Check with a calculator.
5. Since you can't retype this 20,000 times for each item, we need to copy this formula. In Excel, move back to cell "Q2" with your cursor. You should see a small black square in the bottom right of the cell. If you use your cursor to "grab" this square, you can drag your formula into "Q3", "Q4", and so on. Test your dragging before dragging down to the remaining 20,000 items. There are other ways of copying a cell so read your manual if you'd like to experiment.
6. Doublecheck your work by spotchecking 5-10 answers throughout the list.

If this doesn't work after a few tries, leave me a PM and I'll let you email the file to me for 2 minutes of work.

Good luck,

James @ DVDsPlusMore

[gellnsh]

Hi James,

Just tried it and it works beautifully. I knew this could be done. Thank you so much for your help.

cheers
Shell