# How To Satisfy Multiple Conditions Using Multiple Criteria

Oct 16, 2009I'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.