View Single Post
  #4   Report Post  
Bernard Liengme
 
Posts: n/a
Default

or
=COUNTIF(A1:A9,TRUE)=COUNTA(A1:A9)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Arla M" wrote in message
...
What kind of formula would I use to "add" a list of true false statement
to
return TRUE if they are all true, and FALSE if even one is false. Thanks.