Adding True False Results
 

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.

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

=SUMPRODUCT(--(A1:A9))=COUNTA(A1:A9)
best wishes

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

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.

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.

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

"keepITcool" wrote in message
ft.com...

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.

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