Home > Software engineering >  Google sheets - Check all TRUE per row in boolean 2D array with ARRAYFORMULA
Google sheets - Check all TRUE per row in boolean 2D array with ARRAYFORMULA

Time:08-19

I have the following data (created through a ARRAYFORMULA formula):

A B C D
1 TRUE TRUE FALSE TRUE
2 TRUE TRUE TRUE TRUE
3 TRUE FALSE TRUE TRUE

If in a row all values are TRUE, the output for that row should be TRUE. If even 1 is FALSE, it should be FALSE instead. So a formula on the above table should output this:

E
1 FALSE
2 TRUE
3 FALSE

Restrictions

  • The 1st table's size is not fixed. There could be more columns or rows. Therefore, no manual row by row check.
  • It should be 1 function that outputs to multiple rows (like the 2nd table), therefore it should be through the ARRAYFORMULA formula (not dragging a cell down, as this works badly when adding rows/columns at a later stage).

What I tried

AND

AND, but that gives only a single output:

=AND(A1:D3)
# FALSE

Also, enter image description here

  • Related