Z
Zilla
I thought this would AND cells for several rows
in two columns, and put the result where the formula
is, but it doesn't. What syntax am I missing?
I have a mix of 1s & 0s in cols A and B, rows 1-10. I
expect that if a row in both A and B are 1's, col C will have
TRUE, FALSE otherwise. So my array formula in C is,
=AND(A1:A10, B1:B10)
I get FALSE for all C1:C10.
in two columns, and put the result where the formula
is, but it doesn't. What syntax am I missing?
I have a mix of 1s & 0s in cols A and B, rows 1-10. I
expect that if a row in both A and B are 1's, col C will have
TRUE, FALSE otherwise. So my array formula in C is,
=AND(A1:A10, B1:B10)
I get FALSE for all C1:C10.