Adding True False Results

A

Arla M

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

keepITcool

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Loop through pages and insert header image 0
VBA word change keys 0
VBA to look for more than 1 key word and highlights 8
Need help modifying code 0
CleanUpPastedText() 1
How does this formula work ? 2
IF Statement on multiple levels 6

Top