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")
=IF(AND(A3="GB",OR(B3={"EU","N. Ireland"})),"Yes","No")
- many thanks, that works wery well 🙂
Apart from that, I would also need to output N. Ireland and 'EU' or 'Rest of the World' = Yes, otherwise No as an output. Would it be possible to nest this into the formula you have already supplied? I can work out other variations from there I hope!Try
=IF(OR(AND(A3="GB",OR(B3={"EU","N. Ireland"})),AND(A3="N. Ireland",OR(B3={"EU","Rest of World"}))),"Yes","No")
- This worked brilliantly! as this particular scenario has many variations, this is teaching me a lot about nesting tables. I can take it from here as I really need to learn these techniques. Many thanks Hans.
