+ Reply to Thread
Results 1 to 2 of 2

Multiple Criteria pulled from Drop Down Lists

  1. #1

    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


  2. #2
    Toppers
    Guest

    RE: Multiple Criteria pulled from Drop Down Lists

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

    HTH

    "[email protected]" 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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1