IF cell contains multiple text return "Pass", "Fail" or "" (blank)

[jayjay123]

I've set the below formula. It works great when Activity 1-3 have been selected for Pass/Fail.

=IF((AND(D20="Pass",D21="Pass",D22="Pass")),"Pass","Fail")

However, if the Activity section hasn't been filled out yet (or are blank), the Outcome in B35 - B37 default as "Fail"

If the criteria in "Activity 1-3" have not been completed yet, I'd like the Outcome to appear as blank "", rather than "Fail"

Could someone kindly assist with this formula?

Thanks in advanced!

 

[kweaver]

How about:

Book5
	A	B
34	Outcome
35	Activity 1	Pass
36	Activity 2	Fail
37	Activity 3
Sheet1

Cell Formulas
Range	Formula
B35	B35	=IF(OR(ISBLANK(B20:B22)),"",IF(OR("Fail"=B20:B22),"Fail","Pass"))
B36	B36	=IF(OR(ISBLANK(B25:B27)),"",IF(OR("Fail"=B25:B27),"Fail","Pass"))
B37	B37	=IF(OR(ISBLANK(B30:B32)),"",IF(OR("Fail"=B30:B32),"Fail","Pass"))

 

[jayjay123]

This is perfect. Thank you @kweaver!