Formula returning false when it shouldn't

[Paul_Hossler]

Hello, I created the following formula to return either Yes or No. The return of Yes is working corrcetly. But No arguments are returning as false. I cant figure out why. Can anyone help please.

=IF(D4="M",IF(SUM('5'!$O$32:$O$42)>=5,"Yes",IF('5'!$O$32>=1,"Yes","No")))

Thanks you

Back to the beginning

I assume that this should really be to worksheet "4"

=IF(D4="M",IF(SUM('4'!$O$32:$O$42)>=5,"Yes",IF('4'!$O$32>=1,"Yes","No")))

In pseudocode, is this the correct logic

If D4 = "M" Then

     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
    S4 = "No"
EndIf

D4 = "A" s