Need help with multiple conditions formula

[Goddess]

Hi,

I need the result based on 3 scenarios as below. I will have 2 groups of items (however, the groupings will not be specified in the excel sheet when I send out the questionnaire). Based on the reply I get (yes or no answers only), I need the result to return Low, Medium or High. Criteria are:

1) Must have at least 1 "Yes" from each group (one from red box, and another from blue box) for the result to return "Low". If red box have 2 "Yes" but blue box all "No", the result must return "Medium", as per scenario 2.

Thanks again!
Irene

2) Must have at least 1 "Yes" from either group. If all "No" in red box and 2 "Yes" in blue box, then the result should return "Medium" too.

3) If all "NO" or blank, then result should return "High"

 

[Habtest]

See if it works:

Book1
	A	B	C	D	E
1
2		A	B		Result
3	1		Yes		Low
4	2		Yes
5	3		Yes
6	4		No
7	5
8	6		Yes
9	7		No
10	8		No
Sheet1

Cell Formulas
Range	Formula
E3	E3	=CHOOSE(OR(C3:C6="Yes")+OR(C8:C10="Yes")+1,"High","Medium","Low")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Goddess]

See if it works:

Book1
	A	B	C	D	E
1
2		A	B		Result
3	1		Yes		Low
4	2		Yes
5	3		Yes
6	4		No
7	5
8	6		Yes
9	7		No
10	8		No
Sheet1

Cell Formulas
Range	Formula
E3	E3	=CHOOSE(OR(C3:C6="Yes")+OR(C8:C10="Yes")+1,"High","Medium","Low")
Press CTRL+SHIFT+ENTER to enter array formulas.

Hi Habtest!

Thanks for the prompt reply! Appreciate it!!