I.e., if I have:
A | B |
---|---|
TRUE | TRUE |
TRUE | FALSE |
FALSE | TRUE |
FALSE | FALSE |
say I want to create a column C that is A OR B
:
A | B | C |
---|---|---|
TRUE | TRUE | TRUE |
TRUE | FALSE | TRUE |
FALSE | TRUE | TRUE |
FALSE | FALSE | FALSE |
Is this possible with ARRAYFORMULA
or some other method which automatically creates a RANGE of values, without having to rely on auto-filling to increment a single column?
i.e., I'd like to do:
=ARRAYFORMULA(OR(A:A, B:B))
but since OR
can take array inputs, the result of OR(A:A, B:B)
is the single value TRUE
, and the ARRAYFORMULA is also TRUE
.