IF(AND(OR function

[poikl]

Could you please help me with this function so that it should work?
I would like to check in Cel-D2 if it equals either "AA", "AB" and Cel-E2 does not equal "Pass" or it (Cel-E2) equals N/A# then Cel-F2 should show "Problem" otherwise it (Cel-F2) should show "OK" ?

 

[fairwinds]

ISNA(D2)*(E2<>"CK")*(E2<>"BK")

If if D2 is #N/A it returns 1
If E2 is not "CK" it returns 1
If E2 is not "BK" it returns 1

1*1*1=1 wich equals TRUE

As soon as one condition is false e.g.:

1*0*1=0 wich equals FALSE


So... ANDing.