+ Reply to Thread
Results 1 to 5 of 5

Multiple IFs to display one result based on multiple criteria

  1. #1
    Registered User
    Join Date
    06-14-2004
    Posts
    75

    Question Multiple IFs to display one result based on multiple criteria

    Hi Experts!

    Long time since I begged for help on this forum, glad to be back

    I've got a matrix combining actions on the left hand side (Col A) and owners on Cols B to F
    I have drop down list for each action/owner combo: N/A, OK, KO, TBD.

    Owner #1 Owner #2 Owner #3 Owner #4 Owner #5 Results
    Action #1 OK TBD N/A N/A N/A OK
    Action #2 TBD OK OK KO TBD KO
    Action #3

    I would like to create a formula in Col G that does the following:
    • If any of the values in columns B to F equals OK, then OK
    • If any of the values in columns B to F equals KO, then KO

    I've been tinkering with multiple IFs and quite rightly got bogged down as too many criteria to take into account...

    Thanks in advance for your help and advice!

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    650

    Re: Multiple IFs to display one result based on multiple criteria

    I think this works:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Multiple IFs to display one result based on multiple criteria

    try this

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2010
    Posts
    2,308

    Re: Multiple IFs to display one result based on multiple criteria

    you have a condition in the aciton 2 row where KO and OK are both there....I "assumed" you "value" KO over OK....does that make sense?....

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Multiple IFs to display one result based on multiple criteria

    This is an array formula and so needs to be inputted as Ctrl + Shift + Enter (not just Enter):

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display message based on multiple criteria..
    By smartin5 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2014, 01:07 PM
  2. [SOLVED] Drop Down Data Validation - Display a result based on multiple conditions
    By carlmf1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:50 PM
  3. An IF formula result that based on multiple criteria
    By johnfash in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2013, 08:15 AM
  4. Return Result based on Multiple Criteria
    By franciz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-20-2009, 01:30 PM
  5. how can I have a formula result based on multiple criteria/columns
    By nicky_p in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-05-2006, 08:50 AM

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