Thread: how can I calculate cells containing words yes or no
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default how can I calculate cells containing words yes or no

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.
Reply With QuoteReply With Quote