+ Reply to Thread
Results 1 to 4 of 4

how to select price according to item and quantity

  1. #1
    Registered User
    Join Date
    09-24-2010
    Location
    Mandal, Norway
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    3

    how to select price according to item and quantity

    I have a list of about 100 items with four different prices for each items, depending on the number of items sold, and I can't seem to find any logical system in how the prices are set.
    If I select an item from a list in cell a1, and insert the number of the given item in b1, I want c1 to provide one of the four prices, depending on the number of cell b1, and choose from the right four step price list by the item in a1. Please help me!

  2. #2
    Registered User
    Join Date
    09-24-2010
    Location
    Mandal, Norway
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    3

    Re: how to select price according to item and quantity

    Here's an hypothetical example. It is in c8:c11 I want the result.
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    09-24-2010
    Location
    Mandal, Norway
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    3

    Re: how to select price according to item and quantity

    Please forgive my ignorance. Hope this is more helpfull.
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: how to select price according to item and quantity

    See the attached updated sample workbook.

    You'll need to change the price range to show just the lower end of the range.

    Unless you have more prices than items, I'd be inclined to transpose the data as shown in the "restuctured" tab.

    Either way, the formulae provided give the answer you require.

    Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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