Boolean Math

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

I have three cells with formulas that return a boolean value.
I need a formula in the fourth cell that returns True only if the first
three cells are all True.
 
Hi there.
The following formula returns true only if A1, A2 and A3 are all TRUE:

=and(A1,A2,A3)

Regards,
Otávio
 
Assuming your cells are D5:D8 you could use this:
=IF(COUNTIF(D5:D7,"true")=3,TRUE,FALSE)

Hope that helps,

Frank
 
You don't need =IF(...,TRUE,FALSE)
Your formula is the same as =COUNTIF(D5:D7,"true")=3 or
=COUNTIF(D5:D7,TRUE)=3
but AND is easier.
 
This slightly shorter AND method seems to work also (assuming the cells are
contiguous)...

=AND(A1:C1)

or

=AND(A1:A3)
 
Back
Top