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

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

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