Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
=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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grand Totals @ Same Place | Excel Worksheet Functions | |||
True or False Formula? | New Users to Excel | |||
True False | Excel Worksheet Functions | |||
adding if statement results | Excel Worksheet Functions | |||
Nexsted if across 3 columns | Excel Worksheet Functions |