ExcelBanter - conditional formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional formula (https://www.excelbanter.com/excel-worksheet-functions/9828-conditional-formula.html)

Qaspec

conditional formula

I have 3 cells that will return a value of "yes" or "no". In another cell if
any of the other 3 cells has a no I would like it to say "fail", if all 3 are
"yes" I'd like it to say "pass".

A1 yes
B1 no
C1 yes
E2 fail

a1 yes
b1 yes
c1 yes
e2 pass

JE McGimpsey

One way:

E2: =IF(COUNTIF(A1:C1,"yes")=3,"pass","fail")

In article ,
Qaspec wrote:

I have 3 cells that will return a value of "yes" or "no". In another cell if
any of the other 3 cells has a no I would like it to say "fail", if all 3 are
"yes" I'd like it to say "pass".

A1 yes
B1 no
C1 yes
E2 fail

a1 yes
b1 yes
c1 yes
e2 pass

=IF(AND(A1="yes",B1="yes",C1="yes"),"pass","fail")

-----Original Message-----
I have 3 cells that will return a value of "yes" or "no".
In another cell if
any of the other 3 cells has a no I would like it to
say "fail", if all 3 are
"yes" I'd like it to say "pass".

A1 yes
B1 no
C1 yes
E2 fail

a1 yes
b1 yes
c1 yes
e2 pass
.

All times are GMT +1. The time now is 07:21 PM.