Results 1 to 14 of 14

How to satisfy multiple conditions using multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question How to satisfy multiple conditions using multiple criteria

    Hi everyone

    I'm trying to divide my data into 6 different groups, based on 2 different criteria. First, I am not sure how to write the logical test to take 2 columns of data into consideration (using "&" and "AND" do not work; I am not sure what else to try), and second I can't figure out how to write the formula so that it can select from 1 of 6 conditions.

    So, overall here is what I want:

    If DL2=3 and CK2=1, then I want this to be labeled as '1'
    If DL2=3 and CK2=2, 2
    If DL2=1 and CK2=2, 3
    If DL2=2 and CK2=2, 4
    If DL2=1 and CK2=1, 5
    If DL2=2 and CK2=1, 6

    These 6 conditions cover all possible combinations of numbers in the two columns.

    Any help in mashing all this into one beautiful formula would be greatly appreciated!
    Last edited by binkatron5000; 10-16-2009 at 06:58 PM.

Thread Information

Users Browsing this Thread

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

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