+ Reply to Thread
Results 1 to 3 of 3

4 combinations - Display yes if 1 match, Display no if other three

  1. #1
    Registered User
    Join Date
    04-17-2019
    Location
    Appalachia, NC
    MS-Off Ver
    Version 1902
    Posts
    4

    4 combinations - Display yes if 1 match, Display no if other three

    Conditional formula in C9 and C17
    If both display yes, then display yes in C19

    If C9=“Yes” & C17=“No”, then Display No
    If C9=“Yes” & C17=“Yes” then display Yes
    If C9=“No” & C17=“No” then display No
    If C9=“No” & C17=“Yes” then display No

    I’ve tried everything, which would still inaccurately display Yes when C9 and C17 both said No.

    MANY THANKS!!!!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: 4 combinations - Display yes if 1 match, Display no if other three

    The only situation where you need a yes is when C9 and C17 are both Yes otherwise it's No.
    So simply

    =IF(AND(C9="Yes",C17="Yes"),"Yes","No")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-17-2019
    Location
    Appalachia, NC
    MS-Off Ver
    Version 1902
    Posts
    4

    Re: 4 combinations - Display yes if 1 match, Display no if other three

    K,

    You answer was so fast! I was making it much more complicated than it actually was with a multitude of overly complex formulas.

    Thank you so much, worked perfectly!

+ 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. Replies: 2
    Last Post: 08-29-2015, 10:58 AM
  2. Replies: 3
    Last Post: 06-01-2014, 04:19 AM
  3. How to create formula to display different combinations of numbers
    By itsme74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 03:32 AM
  4. Replies: 1
    Last Post: 01-19-2011, 08:49 AM
  5. Replies: 4
    Last Post: 01-09-2007, 07:00 AM
  6. display all possible combinations
    By 1of6Billion in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2006, 01:30 PM
  7. Display all combinations from a set of numbers
    By tx12345 in forum Excel General
    Replies: 7
    Last Post: 07-14-2005, 08:05 PM

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