No, the others are being convoluted <g.

On Thu, 27 Jan 2005 07:43:21 -0800, "keepITcool" wrote:


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