I am trying to use the Multi-Row Formula tool but am not able to get the expected result

[bh1789]

IF [Employee SID] = [Row+1:Employee SID] OR [Employee SID] = [Row-1:Employee SID] AND [Error Type] = [Row+1:Error Type] OR [Error Type] = [Row-1:Error Type]
THEN 1
ELSE 0
ENDIF

This is capturing the following 2 entries as a match and returning a "1" when it should be a "0" because the Error Type does not match, only the Employee SID is a match:

Employee SID = 123456

Error Type = Complaint

Employee SID = 123456

Error Type = Privacy

Can someone please assist?  Thank you!

[bh1789]

Thank you very much for your assistance ... that solution worked and gave me the output I needed.