=IF(COUNTIF(G20:G22,"Pass")=COUNT(G20:G22),"Pass", IF(COUNTIF(G20:G22,"Fail")
0,"Fail",""))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"CJ" wrote in message
ups.com...
In summation, here is what I need!!
if ANY fails exist, then read Fail
if ANY blanks exist, then read blank
if ALL entries = pass, then read pass.

I have cells G20:G22 that can contain either Pass, Fail, or ""
I have a cell H18 that I want to show me the following.

IF *All* G20:G22 = "Pass"
Then "Pass"
ELSE
IF *Any* G20:G22 = "Fail"
Then "Fail"
Else
""
END IF

I'm sure that isn't the correct syntax in code, but I'm trying to
explain it. Here are examples of what I need....

****************
G20 =""
G21 =""
G22 =""
then H18 =""

****************
G20 ="Pass"
G21 =""
G22 =""

then H18 =""

****************
G20 ="Pass"
G21 ="Pass"
G22 =""

then H18 =""

****************
G20 ="Fail"
G21 ="Pass"
G22 =""

then H18 ="Fail"

****************
G20 =""
G21 ="Fail"
G22 =""

then H18 ="Fail"

****************
G20 ="Pass"
G21 ="Pass"
G22 ="Pass"

then H18 ="Pass"



Thanks for your help!!!