+ Reply to Thread
Results 1 to 4 of 4

Compare text in three cells, return with yes or no in fourth cell

  1. 07-10-2014, 11:56 AM #1
    dawsonsoo
    dawsonsoo is offline
    Registered User
    Join Date
    07-14-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    43

    Talking Compare text in three cells, return with yes or no in fourth cell

    Hi,
    I have three cells - A1, B1, C1 and each contains a value of yes or no.

    If more than two of the cells say "yes", I want the fourth cell (D1) to display "yes."

    If less than two columns say "yes", I want the fourth cell (D1) to display "no"

    Could someone please help me? Thank you!

    ~S
    Reply With QuoteRegister To Reply
  2. 07-10-2014, 12:00 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Compare text in three cells, return with yes or no in fourth cell

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



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-10-2014, 12:02 PM #3
    hoyasaxa215
    hoyasaxa215 is offline
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Compare text in three cells, return with yes or no in fourth cell

    =IF(COUNTIF(A1:C1,"Yes")>=2,"Yes","No")
    Reply With QuoteRegister To Reply
  4. 07-10-2014, 03:47 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Compare text in three cells, return with yes or no in fourth cell

    Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare text in a cell to text in a column on another sheet & return text from 3rd cell
    By [email protected] in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 05:33 AM
  2. Compare two cells and "print" data in third cell to fourth cell
    By Timpe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 03:36 AM
  3. [SOLVED] Compare 3 cells and return a value (text) when they are in the same row
    By goga in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 06:33 PM
  4. Compare text strings in two columns and return text from adjacent cell
    By mohitroshan in forum Excel General
    Replies: 6
    Last Post: 02-28-2013, 11:27 AM
  5. Compare Identical Text in two cells on two sheets-return value on target row into cell
    By raze in forum Excel General
    Replies: 3
    Last Post: 01-02-2013, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1