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