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!!!