If and/or

[Legacy 385836]

Hi

I have a spreadsheet to check compliance. I have 3 columns, 2 of which are yes/no and the third is yes/no/N/A.
I need the final column to display No if any of the previous 3 columns show No, and to display yes if al the columns are yes or n/a.

I have tried to use an IF statement and nested IF statements with no luck.

Any help Would be much appreciated.

Thanks.

 

[PlusX EAI]

=IF(COUNTIF(A1:C1;"no")=3;"no";IF(COUNTIF(A1:C1;"yes")+COUNTIF(A1:C1;"N/A")=3;"yes";"-"))

 

[Gerald Higgins]

Or perhaps
=if(countif(A1:C1,"NO")>0,"NO","YES")

 

[PlusX EAI]

That would result in "no" with only one "no" in columns ?

 

[Gerald Higgins]

Yes indeed, which I think is what was requested . . .

I need the final column to display No if any of the previous 3 columns show No

 

[PlusX EAI]

You are right, seems like I was thinking to complicated

 

[Legacy 385836]

Or perhaps
=if(countif(A1:C1,"NO")>0,"NO","YES")

This has worked perfectly!

Thanks for for your help guys!

 

[Legacy 385836]

Is there a way to amend this formula so it doesn't display 'Yes' if the row is blank?

 

[Gerald Higgins]

What do you mean by "if the row is blank" ?

Do you mean "if all values in the range A1:C1 are blank" ?

 

[Legacy 385836]

Yes, so if I drag the formula down and cells A1:C1 are blank it will still show "yes". It's just so when I enter the things I need to check, the final column stays blank until either some data is entered (Yes, No, N/A).