how can I calculate cells containing words yes or no

[Brian N]

I have 3 cells, containing either yes or no. I want to calculation where sum
of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes)
essentially where answers are all yes then the returned sum is Yes and where
the 3 cells are either no or less then 3 yes then the answer would be no.

 

[Jim Cone]

One way...
=IF(LEN(B5)+LEN(C5)+LEN(D5)=9,B5,"No")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Brian N"
wrote in message
I have 3 cells, containing either yes or no. I want to calculation where sum
of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes)
essentially where answers are all yes then the returned sum is Yes and where
the 3 cells are either no or less then 3 yes then the answer would be no.

 

[Gary''s Student]

For A10, A1, A12:

In cell B10 enter:
=IF((A10="yes")*(A11="yes")*(A12="yes"),"yes","no")

 

[Pete_UK]

Try this:

=IF(COUNTIF(A1:C1,"Yes")=3,"Yes","No")

Assumes your Yes/No values are in cells A1 to C1.

Hope this helps.

Pete

 

[Alan]

One more, if the cells are adjacent eg A1:A3,
=IF(COUNTIF(A1:A3,"Yes")=3,"Yes","No")
If not,
=IF(AND(A1="Yes",A6="Yes",A13="Yes"),"Yes","No")
Regards,
Alan.

 

[T. Valko]

Another one:

=IF(A1&B1&C1="yesyesyes","yes","no")

 

[Alan]

That's really good! Most innovative and surprisingly simple. A prime example
of "That obvious, why didn't I think of that?"
Regards,
Alan.

 

[Jarek Kujawa]

yet another one:

=IF(COUNITF(A1:A3,"no"),"no","yes")

assuming the cells may be only populated with yes and/or no

;-)

 

[Jim Cone]

I'm puzzled, why no array formulas? <g>...
{=CHOOSE(OR(B55="No")+1,"Yes","No")}
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Brian N"
wrote in message
I have 3 cells, containing either yes or no. I want to calculation where sum
of cells is no, no, yes (answer is No), or yes, yes yes (answer is yes)
essentially where answers are all yes then the returned sum is Yes and where
the 3 cells are either no or less then 3 yes then the answer would be no.

 

[T. Valko]

"That obvious, why didn't I think of that?"

I find myself saying that quite often!

 

[T. Valko]

why no array formulas?

Good question!

=IF(AND(A1:C1="yes"),"yes","no")

<g>

 

[Jim Cone]

I feel better now. <g>
'--
Jim Cone


"T. Valko"
wrote in message

why no array formulas?

Good question!

=IF(AND(A1:C1="yes"),"yes","no")

<g>

 

[Rick Rothstein \(MVP - VB\)]

A little bit shorter...

=IF(LEN(A1&B1&C1)=9,"yes","no")

Rick

 

[T. Valko]

=IF(LEN(A1&B1&C1)=9,"yes","no")

A1 = yes
B1 = yes
C1 = no<space>

Don't'cha just hate me! <g>

 

[Rick Rothstein \(MVP - VB\)]

Well, if we are assuming stray spaces, then your formula would fail with any
cell containing yes<space>. I would think neither of us has to worry,
though, as the OP specifically said "I have 3 cells, containing either yes
or no" with no mention of trailing space characters.<g>

Rick

 

[SSharp]

Brian, I have 3 columns A is all the yes's B is all the No's and C is the
person's names. I would like to put a formula in columb A & B to count the
yes's and no's. Hope i explained that one right :0) thanks for helping

 

[Roger Govier]

Hi

=COUNTIF(A:A,"Yes")
=COUNTIF(B:B,"No")