array formulas - Google Sheets: ArrayFormula: Alternative To AND()

Question

I understand that using AND() within an ArrayFormula doesn't work, but I haven't found an alternative that I understand.

In col U I have entered an ordinary formula which is copied down the rows. In col T, I wrapped it in an ArrayFormula, which does not work.

I've read on this forum about using "multiplication of truth values" instead, but have no understanding what that means, let alone how to implement it.

question from:https://stackoverflow.com/questions/65600941/google-sheets-arrayformula-alternative-to-and

Answer 1

use:

=INDEX(IF((A2:A13>=58)*(A2:A13<=68), A2:A13, 
       IF((B2:B13>=58)*(B2:B13<=68), B2:B13, )))