=IF(OR(AND(COUNT(D1:E1,"*MEDICARE*")=0,C1<>"ACI MCR"),AND(COUNT(D1:E1,"*MEDICARE*")<>0,C1="ACI MCR")),"ERROR","ACI MCR")
=IF(OR(AND(COUNT(D1:E1,"*MEDICARE*")=0,C1<>"ACI MCR"),AND(COUNT(D1:E1,"*MEDICARE*")<>0,C1="ACI MCR")),"ERROR","ACI MCR")
Posting Permissions
Reply With Quote