Search code examples
excelif-statementexcel-formulacontains

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

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

For example:

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

I want a formula to read this range and show that in row 2, the was a "False" and since there are no falses in row 1 I want it to show "true."

Can anyone help me with this?

Solution

  • As it appears you have the values as text, and not the numeric True/False, then you can use either COUNTIF or SUMPRODUCT 

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