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


"T. Valko" wrote in message
...
=IF(LEN(A1&B1&C1)=9,"yes","no")

A1 = yes
B1 = yes
C1 = no<space

Don't'cha just hate me! <g


--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
A little bit shorter...

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

Rick


"T. Valko" wrote in message
...
Another one:

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


--
Biff
Microsoft Excel MVP


"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.