英文:
ArrayFormula not filling cells
问题
=ARRAYFORMULA({"测试"; IF(AND(M2:M>=80,LEFT(H2:H,2)>=20),"是","否")})
英文:
=ARRAYFORMULA({"test"; IF(AND(M2:M>=80,LEFT(H2:H,2)>=20),"Yes","No")})
My formula isn't expanding beyond the first cell. Not sure what I'm missing. 
答案1
得分: 1
AND() 操作应用于列的所有值，并返回单个结果。使用动态数组公式将结果返回为单独的值。尝试使用 MAP() 函数，如下所示：
={ "测试"; MAP(A2:INDEX(A2:A,COUNTA(A2:A)), B2:INDEX(B2:B,COUNTA(A2:A)), LAMBDA(a,b,IF(AND(a>=80,LEFT(b,2)>=20),"是","否")))}
英文:
AND() operation is applied to all values of column and returning single result. Use dynamic array formula to return result as separate value. Try MAP() function like-
={"Test";MAP(A2:INDEX(A2:A,COUNTA(A2:A)),B2:INDEX(B2:B,COUNTA(A2:A)),LAMBDA(a,b,IF(AND(a>=80,LEFT(b,2)>=20),"Yes","No")))}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论