Parentheses Problems

njpamdnc

New Member
Joined
Feb 16, 2019
Messages
12
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

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
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

New Member
Joined
Feb 16, 2019
Messages
12
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

Well-known Member
Joined
Dec 3, 2018
Messages
7,891
Office Version
2007
Platform
Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,078,394
Messages
5,339,938
Members
399,340
Latest member
JasonT903

Some videos you may like

This Week's Hot Topics

Top