How to check 3 cells for specific values and return yes or no in 4th column?

**kawi6rr** · 02-12-2020, 05:26 PM

I have four cells three of them will either be Yes or NA and the fourth will contain the formula to check for these two values. I'm getting mixed results with this last iteration or formulas I've tried.

Criteria: All three cells Day, Evening, and Night need to be either "Yes" or "NA" to be "Yes" compliant but as you can see I'm getting mixed results in the table below.

Please Login or Register  to view this content.

Day Yes/NA	Evening Yes/NA	Night Yes/NA	Compliant
Yes	NA	Yes	Yes
NA	Yes	NA	No
Yes		NA	Yes

Not sure how to get this figured out any help is appreciated, thanks.

**mehmetcik** · 02-12-2020, 05:40 PM

Hi.

First set data validation on all your cells to only accept Yes, NA and Blank.

Then try this formula in D2

=IF(COUNTBLANK(A2:C2)>0,"No","Yes")

**dosydos** · 02-12-2020, 05:40 PM

try;

=IF(SUMPRODUCT((A2:C2="Yes")+(A2:C2="NA"))=3,"Yes","No")

change cell references accordingly

**kawi6rr** · 02-12-2020, 06:05 PM

Originally Posted by dosydos

try;

=IF(SUMPRODUCT((A2:C2="Yes")+(A2:C2="NA"))=3,"Yes","No")

change cell references accordingly

This worked great thanks!

How to check 3 cells for specific values and return yes or no in 4th column?

LinkBack

Thread Tools

Rate This Thread

Display

How to check 3 cells for specific values and return yes or no in 4th column?

Re: How to check 3 cells for specific values and return yes or no in 4th column?

Re: How to check 3 cells for specific values and return yes or no in 4th column?

Re: How to check 3 cells for specific values and return yes or no in 4th column?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to check column and return multiple values

Search for specific values in a column, and return values of another range of cells

check the value of a cell in a range and return column values of that row

check multiple cells for values and return another value

possible to check for file in multiple folders, then check for values in specific cells?

[SOLVED] Check for values in a specific column

Macro button - check a column values and return msg box

Bookmarks

Bookmarks

Posting Permissions