Thread: how can I calculate cells containing words yes or no
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default how can I calculate cells containing words yes or no
yet another one:

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

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

;-)
Reply With QuoteReply With Quote