4 cells with yes, no list

[googley]

I have 4 cells with a yes,no data validation list. If any of these cells are ="yes" then cell a2="yes" if all are ="no" then A2="no".

It is possible for more than 1 cell to be="yes" then A2 ="yes"

 

[isabelle]

hi,

=IF(COUNTIF(B1:B4,"yes")>1,"yes",IF(COUNTIF(B1:B4,"no")=4,"no","i dont know what
it is"))

or

=IF(COUNTIF(B1:B4,"yes")>=1,"yes",IF(COUNTIF(B1:B4,"no")=4,"no",""))

isabelle

Le 2014-05-11 20:27, googley a écrit :