Forum Discussion
Solved
IF statement with one set condition and multiple others
In the attached excel sheet. I want to show if a Certificate is required for exporting goods from GB only to the EU or N. Ireland. So basically if goods travel from GB to either the EU or N. Ireland...
=IF(AND(A3="GB",OR(B3={"EU","N. Ireland"})),"Yes","No")
fishcultureman Try this one:
=IF(AND(A3="GB",OR(B3="EU",B3="N. Ireland")),TRUE,FALSE)