am i being simplistic?
=and(a1:a10)

works if ALL cells contain boolean formulas.


iso
=COUNTIF(A1:A9,TRUE)=COUNTA(A1:A9)
=if(product(--(a1:a10))=0,"False","true"))



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Arla M wrote :

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.