Excel formula to search, if all cells in the range read "True", if not, then show "False",

Question

Using the excel formula to search, if all cells in the range read "True", if not then show "False"

For instance:

A      B     C     D
True  True  True   True
True  True  FALSE  True

I want the formula to read this range and show that in line 2 it was “False”, and since there are no folds in line 1, I want to show “true”.

Can anyone help me with this?

Answer 1

As it turns out, you have the values ​​as text, not the numeric value True / False, then you can use either COUNTIF, orSUMPRODUCT

=IF(SUMPRODUCT(--(A2:D2="False")),"False","True")
=IF(COUNTIF(A3:D3,"False*"),"False","True")

Answer 2

, TRUE/FALSE:

=AND(A1:D2)

, , - Ctrl + Shift + Enter Enter.

=AND(EXACT(A1:D2,"TRUE"))

Answer 3

=IF(COUNTIF(A1:D1,FALSE)>0,FALSE,TRUE)

(or you can specify any other range to view)