Multiple if Query

[snash]

I need help!

I need help with a formula (in column D) to help me determine 2 categories: Right / Wrong
If my customer name in column A contains the word "Apple" (could be variations of name, And if the country (column B) does not include "Ireland" and if the products (column C) includes "Pen" or "Marker", then call Right or else call it "Wrong".

Any ideas?

Rgds,
Shirley

 

[Joe4]

Here is one way (for an entry on row 1):

=IF(AND(ISNUMBER(SEARCH("Apple",A1)),ISNUMBER(SEARCH("Ireland",B1))=FALSE,OR(ISNUMBER(SEARCH("Pen",C1)),ISNUMBER(SEARCH("Marker",C1)))),"Right","Wrong")

 

[snash]

this is fantastic! Thank you!

 

[Joe4]

You are welcome.

Note that I use the SEARCH function, which is not Case Senstitive (do searching for "Apple" would also find "apple" and "APPLE").
If Case DOES matter, you can substitute using the FIND function (which is Case Sensitive) for all the SEARCH functions.

 

[snash]

Good to know. I prefer the not case sensitive as it'll pick up everything I need.

 

[snash]

So how would I write this if I needed a formula (in column D) to help me determine 2 categories: Right / Wrong
If my customer name in column A contains the word "Apple" (could be variations of name, And if the country (column B) does not include "Ireland" or does not include "UK", then call Right or else call it "Wrong".

 

[Joe4]

And if the country (column B) does not include "Ireland" or does not include "UK"

I think you mean "AND", not "OR". Because if it is was just "Ireland", then it does not include "UK", so your condition would return FALSE.
I think you want it to check that it contains NEITHER "Ireland" NOR "UK", right?
If so, it would look like:

=IF(AND(ISNUMBER(SEARCH("Apple",A1)),ISNUMBER(SEARCH("Ireland",B1))=FALSE,ISNUMBER(SEARCH("UK",B1))=FALSE),"Right","Wrong")