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