Results 1 to 14 of 14

Formula to return multiple criteria in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    massachusetts
    MS-Off Ver
    excel 2010
    Posts
    44

    Formula to return multiple criteria in one cell

    Hi!

    I'm working on a formula for eligibility (insurance). Essentially I have a massive sheet showing eligibility by benefit (A1 would be Medical Insurance, A2 would be either Eligible or Not Eligible, for example).

    I was attempting to make an IF statement that would bring every eligible benefit into one cell, but I'm not entire sure this is the right approach. Cells M2:AR2 are various benefits, each with either that "Eligible" or "Not Eligible" indicator.

    Without listing the entire formula, which didn't exactly get the job done, my format was this:

    =IF(M2="Eligible","Medical Eligible"&IF(N2="Eligible",", Med2 Eligible"&IF(O2="Eligible",", MedPPO Eligible"&IF(P2="Eligible",", MedPPO PHARM Eligible"&IF(Q2="Eligible",", MedPPO VAC Eligible"&IF(R2="Eligible",", Gap Eligible","Not Eligible"))))))

    The formula brings over just one benefit rather than each eligible.

    I'm ultimately attempting to create a cell that shows "Medical Eligible, Gap Eligible, Disability Eligible," etc dependent on cells M2:AR2.
    Attached Files Attached Files
    Last edited by coryjacques; 12-01-2017 at 12:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula return statements on multiple criteria
    By welshman010 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2014, 08:34 PM
  2. [SOLVED] Is there a formula that can Return a text value if multiple criteria are met?
    By beyjul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2014, 03:06 PM
  3. [SOLVED] How to return multiple values to a single cell based on multiple criteria
    By lwallace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 06:32 AM
  4. Replies: 2
    Last Post: 05-12-2014, 08:21 AM
  5. Replies: 4
    Last Post: 03-27-2014, 01:09 PM
  6. [SOLVED] Formula to Return ID based on Multiple Criteria
    By boldcode in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 02:54 PM
  7. [SOLVED] Need a formula that can check multiple criteria and return a value.
    By DeeJay256 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-28-2012, 09:28 AM

Tags for this Thread

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