+ Reply to Thread
Results 1 to 1 of 1

VBA -If Then Statement Using Multiple Criteria

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Clearwater, Florida
    MS-Off Ver
    Excel 2007
    Posts
    28

    VBA -If Then Statement Using Multiple Criteria

    1. Problem:
    What I need to determine is whether the price difference of the BLIST PACK is 0.15 ($0.15) or more than the unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I). If BLIST PACK is more than 0.15 ($0.15) than the lowest price BOTTLE for the Generic Code Num Seq Num then I need to buy it in BOTTLES.
    About the data

    Data example and desired results attached

    Data exists in Columns A-O
    Colum B is an industry number , Generic Code Num Seq Num ,that is specific drug and strength in column C regardless of the quantity the package.

    Colum I is Package Desc. BLIST PACK or BOTTLE
    Column O is Unit Price

    Example:
    DIGOXIN 100 .125 and DIGOXIN 1000 .125 have the same Generic Code Num Seq Num (in this case 18). The strength is 0.125. The numbers 100 and 1000 are the number of tablets in the package.
    NOTE: Some but not all of the products come in BOTTLE and BLIST PACK (Column I).


    Parameters:
    1.) If the unit price BLIST PACK is 0.15 ($0.15) or more that the lowest unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I) then the lowest price BOTTLE for that same Generic Code Num Seq. row should copy across. I would have to buy the lowest price BOTTLE unit cost.
    2.) If the BLIST PACK unit price is NOT more than 0.15 ($0.15) of the lowest unit price of the items for the same Generic Code Num Seq in Colum B that are BOTTLES (Column I) then the lowest BLIST PACK for that same Generic Code Num Seq. row should copy across. In this case I can by the BLIST PACK
    3.) If there is not a BLIST PACK then the lowest unit price for the Generic Code Num Seq. row should copy across.
    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)

Similar Threads

  1. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  2. [SOLVED] If statement that will look among multiple criteria and generate a statement
    By liz5818 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 04:12 PM
  3. [SOLVED] IF Statement with multiple criteria
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-17-2013, 04:42 AM
  4. If statement with multiple criteria
    By Savitri in forum Excel General
    Replies: 2
    Last Post: 06-06-2010, 11:25 PM
  5. Multiple criteria if statement
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 06-22-2006, 02:45 PM

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