Multiple Criteria pulled from Drop Down Lists
 

I am creating a 5 question survey that anyone can answer the simple
questions (from drop down menus) and the spreadsheet will show which
websites to visit based on the answers to the questions. So each
website on the spreadsheet needs to have a set of criteria. For
instance one website might be applicable to Internships, Entry Level,
and Other - which all come from the B2 drop down menu. How do I make a
formula that can have 3 criteria for a SINGLE cell and then other
criteria on top of that?

Right now I have:
=IF((AND(C4="internship",D4="yes",E4="no",F4="no", G4="free")),"Yes","")
which works well for only one - but I need C4="entry level" and I need
G4=both in addition to what they already =.

I tried this - but it doesn't work....
=IF(((C5="internship")*OR(C5="other"))*AND(D5="yes ", E5="No",F5="no",
G5="free"), "Yes", "this won't work")

HELP please :)

Multiple Criteria pulled from Drop Down Lists
 

AND(OR(c5="Internship",c5="other",c5= ....),g4=...., f4=.....)

HTH

" wrote:

I am creating a 5 question survey that anyone can answer the simple
questions (from drop down menus) and the spreadsheet will show which
websites to visit based on the answers to the questions. So each
website on the spreadsheet needs to have a set of criteria. For
instance one website might be applicable to Internships, Entry Level,
and Other - which all come from the B2 drop down menu. How do I make a
formula that can have 3 criteria for a SINGLE cell and then other
criteria on top of that?

Right now I have:
=IF((AND(C4="internship",D4="yes",E4="no",F4="no", G4="free")),"Yes","")
which works well for only one - but I need C4="entry level" and I need
G4=both in addition to what they already =.

I tried this - but it doesn't work....
=IF(((C5="internship")*OR(C5="other"))*AND(D5="yes ", E5="No",F5="no",
G5="free"), "Yes", "this won't work")

HELP please :)