Help with IF Statement Formula

[graemestown]

Hi

I need help with and excel IF statement - How do I write a formula to achieve the answer based on variable condition 1 and condition 2?

Thanks!

Cond 1	Cond 2	ANSWER
FAIL	PASS	PASS
PASS	FAIL	PASS
FAIL	FAIL	FAIL

 

[etaf]

how about
=IF( A2="","", if( AND(a2="fail",B2="fail") , "Fail", "Pass" ))

Book5
	A	B	C	D
1	Cond 1	Cond 2	ANSWER
2	FAIL	PASS	PASS	Pass
3	PASS	FAIL	PASS	Pass
4	FAIL	FAIL	FAIL	Fail
5
6
7
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=IF( A2="","", IF( AND(A2="fail",B2="fail"), "Fail", "Pass" ))

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

Fluff.xlsm
	A	B	C
1	Cond 1	Cond 2	ANSWER
2	FAIL	PASS	Pass
3	PASS	FAIL	Pass
4	FAIL	FAIL	Fail
Data

Cell Formulas
Range	Formula
C2:C4	C2	=IF(COUNTIFS(A2:B2,"pass"),"Pass","Fail")

 

[graemestown]

Perfect - thanks so much, both formulas work!!

 

[Fluff]

Glad we could help & thanks for the feedback.