Formula returning false when it shouldn't

[Paul_Hossler]

S4 should be yes when Sheet 4, O32 >=1, but is returning No.

That doesn't agree with the pseudocode in #15 that you said was correct

Since D4 is NOT = "M" the final Else returns "No"

If D4 = "M" Then   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<< if not "M"

     if SUM('4'!$O$32:$O$42)>=5 Then
        S4 = "Yes"
    
     ElseIf '4'!$O$32>=1 Then
            S4 = "Yes"
     Else
            S4 = "No"
     End IF

Else <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< goes here
    S4 = "No"
EndIf

I'm guessing that there are different checks for M's and A's????

Is this any closer to the logic?

If D4 = "M" Then

     if SUM('4'!$O$32:$O$42)>=5 Then
        S4 = "Yes"
    Else
        S4 = "No"
    Endif

Elseif D4 = "A" Then
     If '4'!$O$32>=1 Then
            S4 = "Yes"
     Else
            S4 = "No"
     End IF

Else
    S4 = "No"
EndIf