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 .当我将该公式复制到第二行时，它会显示 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屋！