ARRAYFORMULA 不添加到每一行 [英] ARRAYFORMULA not adding to each row

问题描述

当我在单元格顶部添加公式时 W2

When I add formula to the top of the cell W2

=ARRAYFORMULA(IFNA(if(and(T2:T="",Q2:Q<>""),"VALID","")))

它在该行上工作正常，但是第二行具有相同的条件，但它不像第一行那样说 VALID.当我将该公式复制到第 2 行时，它会显示 VALID...因此该公式正在运行，它不会自动复制.

It works fine on that row, however the 2nd row has the same conditions, but it does not say VALID like the 1st row does. When I copy that formula to the 2nd row it shows VALID... So the formula is working, it is not copying down automatically.

推荐答案

既然你使用了 ARRAYFORMULA 函数，你应该使用 * 而不是 AND代码>函数.

Since you use the ARRAYFORMULA function you should use * instead of the AND function.

=ARRAYFORMULA(IFNA(IF((T2:T="")*(Q2:Q<>""),"VALID","")))

这篇关于ARRAYFORMULA 不添加到每一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！