IF formula, multiple criteria

[mj_1986]

I have a set of data and need a formula that will give me the result

IF Criteria 1 = Y, Criteria 2 = N, Criteria 3 = N --> Result 1
IF Criteria 1 = Y, Criteria 2 = Y, Criteria 3 = N --> Result 2
IF Criteria 1 = N, Criteria 2 = N, Criteria 3 = N --> Result 3

Any assistance would be greatly appreciated!

 

[Trebor76]

Hi mj_1986,

There's probably an easier way but this will do the job (note zero is return if none of the three criteria are net):

=IF(AND(A2="Y",B2="N",C2="N"),1,IF(AND(A2="Y",B2="Y",C2="N"),2,IF(AND(A2="N",B2="N",C2="N"),3,0)))

You may have to change the cell references to suit.

Regards,

Robert

 

[Scott Huish]

Book1
	A	B	C	D	E
1	Criteria 1	Criteria 2	Criteria 3		Result
2	Y	N	N		1
3	Y	Y	N		2
4	N	N	N		3
5
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=IFERROR(MATCH(A2&B2&C2,{"YNN";"YYN";"NNN"},0),"")