IF, AND, or in one formula

[SamBT]

Hi,

I need a formula to look at specific cells eg P4, R4, T4, AH4, check if they contain the words Pass and return List A, if not True, look at these cells if P contains fail or R contains fail, or T contains fail or AH contains failfaile, then return List C otherwise if excel cant find any of these conditions return list C.

can anyone help with the formula this one I have isnt working
=IF(AND(P4="PASS",R4="PASS",T4="PASS",X4="PASS",AC4="PASS",AE4="PASS",AH4="PASS",AN4="PASS","LIST A"),IF(OR(P4="FAIL",R4="FAIL",AH4="FAIL",AN4="FAIL"),"LIST C"))

 

[awoohaw]

what do you want happening in the yellow scenarios (reading conditions left to right):

WorkBook1.xlsx
	A	B	C	D	E
3		P4	R4	T4	AH4
4	PASS	ListA
5	FAIL		List C	List C	List C
Sheet9

 

[Fluff]

Hi & welcome to MrExcel.
You have List C for two criteria, should one of them be something else?

 

[Fluff]

You're existing formula should be

=IF(AND(P4="PASS",R4="PASS",T4="PASS",X4="PASS",AC4="PASS",AE4="PASS",AH4="PASS",AN4="PASS"),"LIST A",IF(OR(P4="FAIL",R4="FAIL",AH4="FAIL",AN4="FAIL"),"LIST C","LIST ??"))

 

[SamBT]

P	R	T	X	AC	AE	AH	AN	OUTCOMES
PASS	PASS	PASS	PASS	PASS	PASS	PASS	PASS	LIST A
FAIL								List c
	FAIL							LIST C
						FAIL		LIST C
							FAIL	LIST C

ALL COLUMNS MUST BE A PASS TO MAKE LIST A

IF ANY OF THESE COLUMNS CONTAIN A FAIL – LIST C

ELSE LIST B

 

[awoohaw]

try this

WorkBook1.xlsx
	A	B	C	D	E	F	G	H	I
9	R	T	X	AC	AE	AH	AN	OUTCOMES
10	PASS	PASS	PASS	PASS	PASS	PASS	PASS	PASS	LISTA
11	FAIL								LISTC
12									LISTB
13							FAIL		LISTC
14								FAIL	LISTC
Sheet9

Cell Formulas
Range	Formula
I10:I14	I10	=IF(SUM(--(A10:H10="PASS"))=8, "LISTA", IF(SUM(--(A10:H10="FAIL"))>=1,"LISTC","LISTB"))

 

[awoohaw]

try this

WorkBook1.xlsx
	A	B	C	D	E	F	G	H	I
9	R	T	X	AC	AE	AH	AN	OUTCOMES
10	PASS	PASS	PASS	PASS	PASS	PASS	PASS	PASS	LISTA
11	FAIL								LISTC
12									LISTB
13							FAIL		LISTC
14								FAIL	LISTC
Sheet9

Cell Formulas
Range	Formula
I10:I14	I10	=IF(SUM(--(A10:H10="PASS"))=8, "LISTA", IF(SUM(--(A10:H10="FAIL"))>=1,"LISTC","LISTB"))

that is looking at all columns for fail. If the middle four column are moot, then the formula needs to be adjusted

 

[awoohaw]

Here it is with the middle four columns being moot for FAIL or PASS:

WorkBook1.xlsx
	A	B	C	D	E	F	G	H	I
9	R	T	X	AC	AE	AH	AN	OUTCOMES
10	PASS	PASS	PASS	PASS	PASS	PASS	PASS	PASS	LISTA
11	FAIL								LISTC
12				FAIL					LISTB
13				PASS					LISTB
14								FAIL	LISTC
Sheet9

Cell Formulas
Range	Formula
I10:I14	I10	=IF(SUM(--(A10:H10="PASS"))=8, "LISTA", IF( SUM(--(A10:B10="FAIL"))+ SUM(--(G10:H10="FAIL")) >=1,"LISTC","LISTB"))

 

[awoohaw]

I errored, I apologize, the columns are not connected.
Here is the solution using your cell references:

WorkBook1.xlsx
	R		T				X					AC		AE			AH					AM	AN
9	R		T				X					AC		AE			AH					AM
10	PASS		PASS				PASS					PASS		PASS			PASS					PASS	LISTA
11	FAIL																						LISTC
12							PASS																LISTB
13												FAIL											LISTB
14																						FAIL	LISTC
Sheet9

Cell Formulas
Range	Formula
AN10:AN13	AN10	=IF(AND(R10="PASS",T10="PASS",X10="PASS",AC10="PASS",AE10="PASS",AH10="PASS",AM10="PASS"),"LISTA", IF(OR(R10="FAIL",T10="FAIL",AH10="FAIL",AM10="FAIL"),"LISTC","LISTB"))
AN14	AN14	= IF(AND(R14="PASS",T14="PASS",X14="PASS",AC14="PASS",AE14="PASS",AH14="PASS",AM14="PASS"),"LISTA", IF(OR(R14="FAIL",T14="FAIL",AH14="FAIL",AM14="FAIL"),"LISTC","LISTB"))