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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> 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"))