If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

**Koda2013** · 05-28-2014, 03:08 PM

Hi there,
I need to create a function to look at a range of 4 cells, that include yes, or no. If more than one of those cells has Yes, then return Yes into a 5th cell... (and if more than one has No, then return no) I know it is an if statement, but not sure how to do the "look for multiples"...
thanks!

**alansidman** · 05-28-2014, 03:19 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Koda2013** · 05-29-2014, 06:31 PM

HI there,
Basically what I want to automate is taking the data in columns A, B, C, and D, if there is more than one "YES" in those columns, return an answer of "YES" in column E. If there is only one Yes, return an answer of NO. The no's in columns A,B,C,D can essentially be ignored.
Thanks for your help

Excel Forum Workbook.xlsx

**Saarang84** · 05-29-2014, 09:47 PM

Hi,

Welcome to the Forum.

Either of these formulas will work (place it in the Mixed column) :

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

**Koda2013** · 05-30-2014, 10:24 AM

Thank you so much! This is the first time I've used this forum - it was so great to get the help so quickly! Cheers!

**Koda2013** · 05-30-2014, 12:40 PM

I have one other question - is there a way to do a horizontal look up to return the value where there is only one "yes" into that same column?
I've attached the workbook again with a new Before and After.

Thanks again!
Excel Forum Workbook.xlsx

**sktneer** · 05-30-2014, 01:30 PM

May be this......

Please Login or Register  to view this content.

**Koda2013** · 05-30-2014, 01:39 PM

Thanks Sktneer - that works for the first problem, but it doesn't return the column heading, just yes or N/A

**soberguy** · 05-30-2014, 01:56 PM

I do believe the >1 should be =1 for the column heading, then you'd need another if statement for the for the false (which would be the original formula provided).

You're checking if 1 yes and returning the heading, then you need to check >1 or yes=0.

**sktneer** · 05-30-2014, 02:02 PM

See the attached sheet if this is not what you are trying to achieve?

If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

LinkBack

Thread Tools

Rate This Thread

Display

If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Re: If Statements: If Multiple Cell (within a range) contains "x" then Return yes/no

Thread Information

Users Browsing this Thread

Similar Threads

How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"

[SOLVED] Find "X" in range of cells and return various values based on the column "X" is found in.

Search single row range for multiple texts and return "blah" Excel 2003

[SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix

Multiple "IF" statements every cell in range

Bookmarks

Bookmarks

Posting Permissions