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