+ Reply to Thread
Results 1 to 6 of 6

Hi I need help with inventory price change

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Arkansas
    MS-Off Ver
    Excel 2013
    Posts
    1

    Hi I need help with inventory price change

    Hello, I'm using a csv file from a wholesale company and need to increase my prices by 50%. Thanks in advance for your help.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,931

    Re: Hi I need help with inventory price change

    Try =A1*1.5
    should do it.

    EDIT: assumes your price is in A1, click and drag down for increases.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,564

    Re: Hi I need help with inventory price change

    other idea:
    in empty cell write 1.5
    copy (Ctrl+C) that cell
    select all cells with prices
    In the main ribbon under pase you will find small triangle - click it to see Paste Special and click on Paste Special to see dialog window.
    Select "Multiply" and click OK

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,564

    Re: Hi I need help with inventory price change

    PS. If you use Sambo kid approach, it is probably good idea to use a bit more elaborate formula:
    Please Login or Register  to view this content.
    This way you will have prices with no more than 2 decimal places.
    Otherwise with original price of 10.99 you would get 16.485

  5. #5
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Hi I need help with inventory price change

    You can use any unused cell in the top row for the % to be increased increased. for eg: if you data has 4 columns then you can use the 5th column ie E1 and type 50%.
    and suppose your cost is in A2 then type the formula in E2 like =A2+(A2*$E$1) and copy the formula down. In this case you can change the value in E1 always and you will get the new price without changing the formula.
    HTH
    Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me

  6. #6
    Registered User
    Join Date
    06-28-2013
    Location
    Jalgaon
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Hi I need help with inventory price change

    Hi i want to creat a list of few names so that when i enter one name and scroll down the list automatically displayed...as in the case of days or numbers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tough Inventory Weighted Average Price Problem, Please Help!
    By 1337 Ninja in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2013, 10:15 PM
  2. Master inventory product price changes with new order
    By Mmurra22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2013, 09:13 PM
  3. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  4. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  5. Supplier Inventory Best Price Analsysis
    By pilkingtond in forum Excel General
    Replies: 0
    Last Post: 08-27-2010, 05:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1