"MATCH" or "IF/OR"

[geniechua]

Hi,

I have to find a solution which I'm not entirely sure if it can be done by excel.

I have a table with 11 conditions, and depending on whether the conditions are met, there will be 4 outcomes.

	A	B	C
1	Condition 1	True	Result A
2	Condition 2	False	Result A
3	Condition 3	False	Result B
4	Condition 4	True	Result B
5	Condition 5	False	Result B
6	Condition 6	False	Result B
7	Condition 7	False	Result B
8	Condition 8	True	Result B
9	Condition 9	True	Result B
10	Condition 10	True	Result C
11	Condition 11	False	Result D

<tbody>
</tbody>

Here's the restrictions to be imposed:

1. If either Condition 1 or Condition 2 is true, I want Result A. Whether any other conditions are true is irrelevant.
2. If any of Condition 3 to Condition 9 is true, I want Result B. This is regardless whether Condition 10 or Condition 11 is true
3. If only Condition 10 or Condition 11 is true, I want Result C and Result D respectively.

 

[AlanY]

how about?

=IF(AND(B10,COUNTIF(B1:B11,TRUE)=1),"Result C",IF(COUNTIF(B3:B9,TRUE)>0,"Result B"))

 

[geniechua]

Actually the earlier formula without the OR works! Thanks so much!!!