Multiple Criteria pulled from Drop Down Lists

C

carly.westcott

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If C2 is Sunday how do I make D 2 to the next day of the week 2
Fill down formula (but changing cell value by two) 1
problem in Excell 2003 4
Transfer data from a cell to another workbook if certain criteria 14
Define drop-down results that are variable and dependent upon the. 4
Too many IF functions 3
Recorded macro selection widened 4
How To Use Range Names In Data Validation Criteria (Not For Lists) 1

Top