how can I calculate cells containing words yes or no
That's really good! Most innovative and surprisingly simple. A prime example
of "That obvious, why didn't I think of that?"
Regards,
Alan.
"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.
|