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!
Bookmarks