IF statement with one set condition and multiple others

[fishcultureman]

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, then a certifcate is required (output 'True'), otherwise not required (output 'False').



So far I only know how to get 'True' if GB = EU as per the formula below.

=IF(AND(A3="GB",B3= "EU"),TRUE,FALSE)



On that, I would appreciate it if someone could tell me how to put in multiple conditions (EU or N. Ireland) for cell B3

[Pepe Le Mokko]

Try

Please Login or Register  to view this content.

[AliGW]

Welcome to the forum.

Try this:

=IF(AND(A3="GB",OR(B3= "EU",B3="N. Ireland")),"Y","N")

[fishcultureman]

Try

Please Login or Register  to view this content.

Sorry - no luck with that. The Output needs to be True if GB is selected with either EU or N. Ireland as a selection.

[AliGW]

That's exactly what it does!!!

AliGW on MS365 Insider (Windows) 32 bit

	A	B	C
2	Export Start Point	Export Destination
3	GB	EU
4
5	Is Certificate required (Y/N)	Y	AliGW
6		TRUE	Pepe

Sheet: Raw

AliGW on MS365 Insider (Windows) 32 bit

	A	B	C
2	Export Start Point	Export Destination
3	GB	N. Ireland
4
5	Is Certificate required (Y/N)	Y	AliGW
6		TRUE	Pepe

Sheet: Raw

[Pepe Le Mokko]

I then suppose there is a space before The "I" of "Ireland like N. Ireland ?
Easily corrected

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.