Thread: how can I calculate cells containing words yes or no
View Single Post
  #12   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

I feel better now. <g
'--
Jim Cone


"T. Valko"
wrote in message
why no array formulas?
Good question!

=IF(AND(A1:C1="yes"),"yes","no")

<g
--
Biff
Microsoft Excel MVP


Reply With QuoteReply With Quote