Multiple variables forIF and COUNTIF

[Quality Geek]

OK, I am still an amateur at writing formulas and I am trying to think about how to explain what I am trying to do. (Column C will not change values)

In H4; if D4 is greater than C4 with 1 Eval in G4 = Fail; if D4 is equal to C4 with 1 Eval in G4 = Pass. (H5:H11 have my original formula)

Here is the part I cannot figure out with cells E4 and F4.
If D4 is greater than C4 and E4 equals C4 with 2 in G4 = Pass;
if D4 and E4 equal C4 with 2 in G4 = Pass;
if D4 equals C4 and E4 is greater than C4 and 2 in G4 = Fail;
if D4 and E4 are greater than C4 and 2 in G4 = Fail;
if F4 is greater than C4 E4 with 3 in G4 = Fail;
if F4 equals C4 and equals E4 with 3 in G4 = Pass;
if F4 is greater than C4 and equal to or greater than E4 with 3 in G4 = Fail.

What I am trying to do is establish a Pass or Fail in that row. The Pass is based upon the cell being equal to or less than the Column C cell within that row and the Fail is based upon the cell being greater than the Column C cell within that row.

If 1st Eval Pass and no other Evals then Pass.
If 1st Eval Fail and no other Evals then Fail.
If 1st Eval Pass and 2nd Eval Fail and no other Eval then Fail.
If 1st Eval Fail and 2nd Eval Pass and no other Eval then Pass.
If 1st Eval and 2nd Eval Pass and 3rd Eval is Fail then an overall Fail.
If 1st Eval Pass and 2nd Eval Fail and 3rd Eval Pass then overall Pass.
If 1st Eval Pass and 2nd Eval Fail and 3rd Eval Fail then overall Fail.
If 1st, 2nd and 3rd Evals Pass then overall Pass.
If 1st, 2nd and 3rd Evals Fail then overall Fail.
Does this make sense?
I hope that someone can help me with this one. I received fantastic help for cell H12.

Thank you in advance!

[protonLeah]

You are confusing the functions of the logical-AND operator and the string building (concatenating) & operator:

Please Login or Register  to view this content.

"apples" AND "ORANGES" ==> ERROR!
"APPLES" & "ORANGES" = "APPLESORANGES"

H4: =IF(AND(D4>C4,G4=1),"Fail",IF(AND(C4=D4,G4=1),"Pass",""))

D4>C4 evaluates to either True or False. D4= 1 / C4 = 0: D4>C4 ---> True. D4&C4 ===> 10, C4&D4 ---> 01