Parentheses Problems

[njpamdnc]

Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL BE a good match for conversations(yes); and people who I think WILL NOT BE a good match for conversations(no). I know what I want, but I don't think I am correctly using the parentheses.


=IF(L4="","",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),AND(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4))))),"maybe",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),NOT(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4)))))),""yes","no"))

 

[DanteAmor]

I put the problem of parentheses in red

Your formula

=IF(L4="","",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),AND(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4))))),"maybe",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),NOT(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4)) )) )),""yes","no"))

Updated formula
=IF(L4="","",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),AND(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4))))),"maybe",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),NOT(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4)) )) ),""yes","no")))

 

[njpamdnc]

I put the problem of parentheses in red

Your formula

=IF(L4="","",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),AND(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4))))),"maybe",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),NOT(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4)) )) )),""yes","no"))

Updated formula
=IF(L4="","",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),AND(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4))))),"maybe",IF(AND(ISNUMBER(SEARCH("Greg",L4)),ISNUMBER(SEARCH("Rodney",L4)),ISNUMBER(SEARCH("Mari",L4)),NOT(OR(ISNUMBER(SEARCH("Omar",L4)),ISNUMBER(SEARCH("Renee",L4)),ISNUMBER(SEARCH("Diane",L4)),ISNUMBER(SEARCH("Marvin",L4)) )) ),""yes","no")))

Hi DanteAmor...Your formula fix works...Thank You!!!

 

[DanteAmor]

You're welcome & thanks for the feedback.