View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=if(product(--(a1:a10))=0,"False","true"))
Aray-entered (ctrl+shift+enter)


"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.