Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.0k views
in Technique[技术] by (71.8m points)

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

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

enter image description here 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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

use:

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

enter image description here


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...