how can I calculate cells containing words yes or no
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
On Mar 24, 11:26*pm, Brian N wrote:
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. *
|