Need help with multiple if conditions

We are trying to calculate the number of data entry errors our team caused in a month.

We have 4 columns: LastName, FirstName, Degree, Salutation. What the proper Salutation should be is determined by the Degree. If an MD/DO it must be “Dr. LastName”, if any other Degree it must be “FirstName”.

I’m trying to create a formula where if the degree is not MD or DO and the Salutation contains “Dr.”, or if the Degree is MD or DO and the Salutation does not contain “Dr.” you get a result of 1. I’m using
=IF(OR(AND(ISNUMBER(SEARCH("*Dr.*",D5)),OR(C5="MD",C5="DO")),AND(ISNUMBER(SEARCH(B5,D5)),OR(C5<>"MD",C5<>"DO"))),0,1)
but this isn’t working for an MD/DO whose Salutation is wrong, and I cannot figure out how else to get it to work.

Thanks!

Or try this in E2 and copy down

Formula:

Please Login or Register  to view this content.

Neither of those worked for all contingencies, but they did help me find a solution of
=IF(AND(OR(C2="MD",C2="DO"),D2="Dr. "&A2),0,1)-IF(AND(OR(C2<>"MD",C2<>"DO"),D2=B2),1,0)+IF(AND(OR(C2="MD",C2="DO"),D2=B2),1,0)


Thank you so much for all your help!