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
ARRAYFORMULAformula (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

