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")
Other words EU is still not "Rest of the world". Intresting.
This is about varying the GB entry this time to N. Ireland, to either get a yes or no, and nesting it within the last formula. It may not be possible.